crmpicco
10-21-2007, 11:51 AM
My host only allows me to create a database with the name of my username then my custom db name, i.e. "ayrshire_crmpiccomini".
My DB is called "crmpicco_mini" on my local machine and I found a command on the MySQL site called "RENAME DATABASE" which is what I am looking for as I need to rename my table to "ayrshire_crmpiccomini".
However, it does state the command has been added for 5.1.7 (which I believe is still beta - which is fine). I am running 5.0.41, but would like to upgrade to use this command to change my db name.
Does anyone know how I can do this? I don't want to destroy the setup I have just now in the process :=)
Cheers,
Picco
My DB is called "crmpicco_mini" on my local machine and I found a command on the MySQL site called "RENAME DATABASE" which is what I am looking for as I need to rename my table to "ayrshire_crmpiccomini".
However, it does state the command has been added for 5.1.7 (which I believe is still beta - which is fine). I am running 5.0.41, but would like to upgrade to use this command to change my db name.
Does anyone know how I can do this? I don't want to destroy the setup I have just now in the process :=)
Cheers,
Picco