+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Clean Install, can I change MySQL Prefix (/thread-2486.html)
Clean Install, can I change MySQL Prefix - owhosting - 02-19-2008 05:09 AM
I made a mistake on my clean install, I chose to use prefix for mysql database, being that I am moving several sites over and do not feel like editing hundreds of pages I need this option to not exist. Is there a simple way to remove it or am I screwed?
In addition is it possible to run dif versions of PHP on dif sites. One site in particular is not compatible with php 5 whereas the rest are.
RE: Clean Install, can I change MySQL Prefix - Cube - 02-19-2008 05:25 AM
Quote:Is there a simple way to remove it or am I screwed?In /etc/ispcp/ispcp.conf you should change MYSQL_PREFIX to no.
Quote:In addition is it possible to run dif versions of PHP on dif sites.Please search the forums, this was already answered many times.
RE: Clean Install, can I change MySQL Prefix - owhosting - 02-19-2008 05:32 AM
Thank you, I always search before I post, I will search more I have a million things going on with moving everything over to my new server so I admit I was lazy...Thanks for the quick response!
RE: Clean Install, can I change MySQL Prefix - joximu - 02-19-2008 06:20 AM
the mysql_prefix is only important while creating the dbs and db users.
I like it because then there is no duplicate in db names.
If the user-id changes then the db names does not have to change too - the uid is put infront of th names only when creating the db and/or user...
/J