Hi,

Just wonder is there any way to create a MySQL database manually without using the database wizard from H-Sphere control panel?? As the database wizard always put the main domain name of the account before the database such as ABCD_ , etc; which is quite annoying (also you don't have many characters left to make a sensible database name)....

I've been told that this is impossible to use phpadmin as the MySQL database server and the web server are on separate machines (the way H-Sphere works) ...

cheers
Wallace :confused:

Your host should be able to turn this off.. Ours does it with account ID I think so its like 7 or 8 numbers.. Using the domain would be kind of funny since it could be up to I think 64 for letters now for a domain.. I think thats the MAX on them.. That would suck with a long domain.

Hello,

The only way to create the DB in hsphere is with the wizard. But Vortech is right, the host is able to turn this off. (we dont use DB prefixes unless a customer requests it - which has never happened)

Also, the host can choose if the MySQL server and Web server are on the same machines or different. There are many advantages to separating the 2, however, the host is not doing this because of any limitation in hsphere.

Hi,

I'm sorry that I didn't mean domain name as prefix, I mean username as prefix

http://www.psoft.net/HSdocumentation/user/mysql_support.html#create

According to the menu, any version starting from 2.3.1, new MySQL database are created with username_prefix, can this be switched off like what you have suggested??? If so, can this be switched off on my account or need to be done for EVERYONE ???

Most H-Sphere (windows account) only have limited billable accounts (mean only limited no. of control panel) available. I've hosted more than 12 domains (personals and friends) under the same username.

The H-Sphere came with phpBB and oscommerce, the problem is ...

eg. the username is "customer"

imagine I have 10 websites, and ALL of them would love to have a forum .. ie. phpBB

By using the wizard, it would "force" me to start with something like ... "custome1_"

so if I want to install 10 forums for 10 domains under the SAME username or account, then I need to create

custome1_phpBB1

custome1_phpBB2

this makes the name of the database quite clumsy :eek:

But according to the documentation of H-Sphere, " ... This is done to prevent the creation of databases with the same name under different users ..."

thanks
Wallace :cartman:

Originally posted by wallacetai
Hi,

I'm sorry that I didn't mean domain name as prefix, I mean username as prefix



so if I want to install 10 forums for 10 domains under the SAME username or account, then I need to create

custome1_phpBB1

custome1_phpBB2

this makes the name of the database quite clumsy :eek:

But according to the documentation of H-Sphere, " ... This is done to prevent the creation of databases with the same name under different users ..."

thanks
Wallace :cartman:

Hello,

Yes, the host can turn it on or off for the entire system in Hsphere - we leave it off. This does mean that there are no prefixes for the DB's, but it also means that there cannot be 2 DB's with the same name on the system. This has yet to be a problem for us (other then the odd customer inquiry about it).

Im sure you can imagine the benefit of not having 2 or more databases with the exact same name. especially in a disaster recovery scenario.

Too bad it's not my server :bawling:

I think it would be too much to ask my host to turn it off for me alone, but maybe I'll try to ask ....

cheers
Wallace