Forum Moderators: open

Message Too Old, No Replies

changing a databse name manually via putty

how do you update the listing in plesk?

         

mike73

8:49 pm on Jun 27, 2006 (gmt 0)

10+ Year Member



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)

10+ Year Member



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)

WebmasterWorld Senior Member 10+ Year Member




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.