Rename a database in MySQL through Linux console

Steps to follow to rename a database in a Linux environment can be listed as follows.

1. Stop mysql
   • Use $ kill -9 [processID]
2. Search the place where the database folders are stored
   • Use $ mysqladmin variables | grep datadir
3. Goto the folder which contains the database folders
4. Rename the folder
   • Use $ mv
5. Start mysql
   • Use $ mysqld_safe &

Share this article please, on :

Share on fb Tweet Share on G+