Clean Install, can I change MySQL Prefix

[owhosting]

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.

[Cube]

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.

[owhosting]

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!

[joximu]

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