I've changed the name of a DB simply by renaming the folder on the server using putty. My DB connections and sites that use the DB are working fine, but how do I update the server so the new DB name shows in Plesk?
Thanks in advance for your help.
FalseDawn
11:20 pm on Jun 27, 2006 (gmt 0)
It's generally not a good idea to just change folder names and assume that all will be well and good. The actual database name is probably stored in many other places, too.
Is there no tool in Plesk to accomplish this? That would probably be the best way to go.
physics
5:48 am on Jun 28, 2006 (gmt 0)
It's generally not a good idea to just change folder names and assume that all will be well and good. The actual database name is probably stored in many other places, too.
I agree, this is a bad idea. If you want to mess with MySQL from within putty feel free, just type $mysql -uyourusername -p at the command prompt. You can rename things from in there (or in this case perhaps copy the db to a new db with the new name). Hope you didn't mess up your db... you may want to change the name back and then do it the proper way.