如何通过mysql工作台将数据导入mysql数据库?

更新时间：2022-06-02 22:02:44

服务器管理下，选择要将数据库还原到的服务器实例(如果是首次创建，请创建新服务器实例).
点击管理导入/导出
点击屏幕左侧的数据导入/还原.
选择从自包含文件导入单选按钮(屏幕右侧)
选择.sql的路径
点击窗口右下角的开始导入按钮.

Under Server Administration on the Home window select the server instance you want to restore database to (Create New Server Instance if doing it first time).
Click on Manage Import/Export
Click on Data Import/Restore on the left side of the screen.
Select Import from Self-Contained File radio button (right side of screen)
Select the path of .sql
Click Start Import button at the right bottom corner of window.

希望有帮助.

---编辑的答案---

---Edited answer---

关于模式的选择. MySQL Workbench(5.2.47 CE Rev1039)尚不支持导出到用户定义的架构.它将仅创建导出了.sql的架构.在5.2.47中，我们看到新建"目标架构.但这是行不通的.我使用MySQL Administrator(Oracle Oracle MySQL之前的旧版本)进行备份/还原. 您仍然可以从Googled可信来源下载它(搜索MySQL Administrator 1.2.17).

Regarding selection of the schema. MySQL Workbench (5.2.47 CE Rev1039) does not yet support exporting to the user defined schema. It will create only the schema for which you exported the .sql... In 5.2.47 we see "New" target schema. But it does not work. I use MySQL Administrator (the old pre-Oracle MySQL Admin beauty) for my work for backup/restore. You can still download it from Googled trustable sources (search MySQL Administrator 1.2.17).

上一篇 : ：如何配置MySql连接工作台下一篇 : MySQL 工作台错误 1064

如何通过mysql工作台将数据导入mysql数据库?

相关阅读

技术问答最新文章