Shulou(Shulou.com)06/01 Report--

Editor to share with you the method of changing the name of the library by mysql. I hope you will gain a lot after reading this article. Let's discuss it together.

You can modify the name of the MySQL database as follows:

1. Sentence modification method:

RENAME DATABASE db_name TO new_db_name

This syntax was added in mysql 5.1.7 and removed in 5.1.23.

two。 If all tables are of MyISAM type, you can change the name of the folder

Rename the db_name directory in the data directory to new_db_name

3. Rename all tables

The code is as follows:

4. Mysqldump exports data and then imports

The code is as follows:

5. Rename all tables using the shell script

The code is as follows:

After reading this article, I believe you have a certain understanding of the method of changing the database name of mysql. I would like to know more about it. Welcome to follow the industry information channel. Thank you for your reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.