没有不值得去解决的问题,也没有不值得去学习的技术!

How to Rename a Database in Navicat for MySQL

Refresh the database gsy2aa-test to confirm that both the structure and data are consistent with the database g-s-yii2-app-advanced-test

1. In Navicat for MySQL, when editing a database, the database name cannot be edited, as shown in Figure 1.

In Navicat for MySQL, when editing a database, the database name cannot be edited
Figure 1

2. Renaming a database in phpMyAdmin shows that phpMyAdmin supports direct renaming operations, as shown in Figure 2.

Renaming a database in phpMyAdmin shows that phpMyAdmin supports direct renaming operations
Figure 2

3. I plan to rename g-s-yii2-app-advanced-test to gsy2aa-test in Navicat for MySQL by creating a new database: gsy2aa-test, as shown in Figure 3.

Plan to rename g-s-yii2-app-advanced-test to gsy2aa-test in Navicat for MySQL by creating a new database: gsy2aa-test
Figure 3

4. On the database g-s-yii2-app-advanced-test, I dump the SQL file – structure and data, exporting the file: g-s-yii2-app-advanced-test.sql, as shown in Figure 4.

On the database g-s-yii2-app-advanced-test, dump the SQL file - structure and data, exporting the file: g-s-yii2-app-advanced-test.sql
Figure 4

5. On the database gsy2aa-test, I run the SQL file and select the SQL file just exported, as shown in Figure 5.

On the database gsy2aa-test, run the SQL file and select the SQL file just exported
Figure 5

6. I refresh the database gsy2aa-test to confirm that both the structure and data are consistent with the database g-s-yii2-app-advanced-test, as shown in Figure 6.

Refresh the database gsy2aa-test to confirm that both the structure and data are consistent with the database g-s-yii2-app-advanced-test
Figure 6

7. Delete the database g-s-yii2-app-advanced-test, as shown in Figure 7.

Delete the database g-s-yii2-app-advanced-test
Figure 7

关于作者 · 持续学习与技术实践

我是一名拥有 15 年以上开发经验的技术从业者,自 2013 年起持续运营个人技术博客,记录工作与个人项目中遇到的真实问题,以及解决问题过程中的探索、实践和思考。

除了技术写作,我也在持续开发和维护自己的独立项目,探索新技术和新工具在实际场景中的应用。我始终相信,没有不值得去解决的问题,也没有不值得去学习的技术。

如果这篇文章对你有所帮助,欢迎浏览博客中的其他文章,也欢迎交流技术经验与想法。

关于我  ·  GitHub  ·  邮件联系