&nbps;Home โœˆ๏ธ Travel โšพ Baseball ๐Ÿ›  Tech ๐Ÿ“˜ Language ๐Ÿ‘จ๐Ÿป Politics About Y Generation  ๐Ÿ˜ˆ
/ tech-note

How to rename a database in MySQL?

Take the following steps:

mysqldump -uUSERNAME -p DBNAME > FILENAME.sql
mysql -uUSERNAME -p -e "create database NEW_DBNAME;"
mysql -uUSERNAME -p NEW_DBNAME < FILENAME.sql
How to rename a database in MySQL?
Share this