mysql workbench 复制,通过workbench导出导入将mysql数据库及其包含的所有数据复制到其他计算机...

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?

解决方案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[^]