Post Reply 
Clean Install, can I change MySQL Prefix
Author Message
owhosting Offline
Junior Member
*

Posts: 32
Joined: Feb 2008
Reputation: 0
Post: #1
Clean Install, can I change MySQL Prefix
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.
02-19-2008 05:09 AM
Find all posts by this user Quote this message in a reply
Cube Offline
Documentation Team
***
Docu Team

Posts: 687
Joined: Apr 2007
Reputation: 8
Post: #2
RE: Clean Install, can I change MySQL Prefix
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.
02-19-2008 05:25 AM
Find all posts by this user Quote this message in a reply
owhosting Offline
Junior Member
*

Posts: 32
Joined: Feb 2008
Reputation: 0
Post: #3
RE: Clean Install, can I change MySQL Prefix
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!
02-19-2008 05:32 AM
Find all posts by this user Quote this message in a reply
joximu Offline
Moderator
*****

Posts: 3,815
Joined: Jan 2007
Reputation: 47
Post: #4
RE: Clean Install, can I change MySQL Prefix
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

2008-08-05 ispCP RC6 released!!!
02-19-2008 06:20 AM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


| All rights reserved : isp-control.net |