I was hoping this was available (and it might be) in SolidCP:
- Can I configure somewher to install the membership tables into a DB when it is created or do I still have to do this using aspnet_regsql.exe from the server?
- Where can I define where the SQL files are created? Right now they are being created under C:Program Files….. which is the default, I realize, for the server. Ideally I would like it under the HostingSpacesusername tree.
- I don’t believe this is possible in SCP.
- This is governed by the SQL installation default user database directory. You can change it as per this article. However, I don’t think you will be able to have the databases under HostingSpaces -> Username as they need to be central (i.e. E: -> MSSQL)
For issue 1:
It’s indeed not possible, way around it is mylittleadmin but can be a bit pricy.
Actually for issue 2.:
You can modify the database path from the provider settings in SolidCP : configuration –> servers –> your mssql service
It has a setting “Database Location” you can also use variables like [USER_NAME]
Do note that i am not sure if i would put it under hostingspaces (or if it’s even capable of doing so or just creating a new directory with +1 infront of it). but you can atleast put it under a customers folder so group them up per user.
Well you live and learn 🙂
Marco: Any reason why this is available for MSSQL but not MySQL?
Note that storing a database in the user’s hosting space directory means it will probably be counted as both database space AND file space, further confounding some other disk space counting issues I wrote about: https://solidcp.com/forum/question/disk-space-report/
Meanwhile, I don’t know if it’s even possible to configure MySQL databases in different directories, although you might be able to do something with symbolic links, hard links, or junctions.
#1 I scripted the whole thing from a working clean membership folder. So I only need to run this single SQL script and it does everything for me so that’s one solution.
#2 I was doing this primarily for backup reasons. I mean there is a DATA folder after all. It would make sense that all of a customer’s data would be under the same tree doesn’t it?