通过workbench导出导入将mysql数据库及其包含的所有数据复制到其他计算机 [英] copy mysql database with all data it contain to other computer through workbench export import

问题描述

我想将所有表格，即包含其整数的整个数据库复制到其他计算机上。我通过mysql workbench export import做到了。我做了导出然后导出文件复制到其他计算机上，我导入那些导入成功但未显示该数据库的文件，有什么问题？或者我们还要做更多的事情？它位于何处？

i want to copy all tables i.e whole database with its contains to other computer. i did it through mysql workbench export import. i did export then exported file copied on other computer and there i import those files it import successfully but not showing that database, what is problem? or we have to do something more? to where it is located?

推荐答案

导出/导入向导可用于导出单个表，然后将其导回。只需确保

- 您选择所有列

- 您选择要包含的数据

- 导出到本地机器

- 导入时选择创建新表

- 并对所有表重复此操作



有关更多信息，请参阅 6.5.1表数据导出导入向导 [ ^ ]



另一种方法可能是使用备份/恢复，请参阅 6.7.3备份恢复 [ ^ ]

The Export/Import wizard can be used to export a single table and then import it back. Just make sure that
- you select all columns
- you select the data to be included
- export to local machine
- when importing select the create new table
- and repeat this for all tables

For more information refer to 6.5.1 Table Data Export and Import Wizard[^]

Another approach could be to use backup/restore, see 6.7.3 Backup Recovery[^]

这篇关于通过workbench导出导入将mysql数据库及其包含的所有数据复制到其他计算机的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！