rename database name - mysql [closed]

Question

how i can rename my database? There is any way in phpmyadmin? or what is the sql code?

I have already tried using RENAME DATABASE

thanks

Answer 1

If you're using MyISAM only, the quickest way is

/etc/init.d/mysql stop
cd /var/lib/mysql
mv <old db name> <new db name>
/etc/init.d/mysql start

It's not pretty, but it does work. You'll need root access.

This way might work if you're using InnoDB tables, but I have no experience there, so I won't vouch for it.

Answer 2

Here is an answer from SO: How do I quickly rename a MySQL database (change schema name)?

This seems to be your best bet. The RENAME DATABASE command, if it is even available to you, may wipe your data. Don't pursue that angle.