Rename a database in MySQL through Linux console - Digizol6

Post Top Ad

Responsive Ads Here

Post Top Ad

Responsive Ads Here

Tuesday, December 6, 2005

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 &

1 comment:

Post Top Ad

Responsive Ads Here