Creating SQL Databa...
 
Notifications
Clear all

Creating SQL Databases - 2 questions

6 Posts
4 Users
0 Likes
3,226 Views
Posts: 6
Topic starter
(@jglazer)
Active Member
Joined: 7 years ago

I was hoping this was available (and it might be) in SolidCP:

  1. 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?
  2. 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.

Thanks!

5 Replies
Posts: 60
 Ric
(@ric)
Trusted Member
Joined: 8 years ago

Hi,

  1. I don't believe this is possible in SCP.
  2. 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)

Ric

Reply
Posts: 1964
Admin
(@m-tiggelaar)
Noble Member
Joined: 8 years ago

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.

Regards,

Marco

Reply
Posts: 60
 Ric
(@ric)
Trusted Member
Joined: 8 years ago

Well you live and learn 🙂

Marco: Any reason why this is available for MSSQL but not MySQL?

Reply
Posts: 68
(@dolphyn5)
Estimable Member
Joined: 7 years ago

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.

Reply
Page 1 / 2
Share: