Skip to main content

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 &

Comments

Post a Comment

We appreciate your opinions, suggestions and criticism.

Popular posts from this blog

Web Services with Apache Axis 1.4 Tutorial: server and client sides

Java Sorting: Comparator vs Comparable Tutorial

Creative Commons License Digizol by Kamal Mettananda is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 License .
URL of this page must be supplied in attribution
© 2004-2017