Mysql：转储/将现有数据导出到.sql文件

I have a database. All I want to do is dump ALL the existing data in every table to I can then use it to simply import the SQL to my new database?

我有一个数据库。我想要做的就是将所有现有数据转储到每个表中然后我可以用它来简单地将SQL导入到我的新数据库中吗？

Im presuming the dump will be a bunch of MySQL INSERT statements

我假设转储将是一堆MySQL INSERT语句

2 个解决方案

#1

You can also use mysqldump, native mysql tool for this purpose.

您也可以使用mysqldump，本机mysql工具来实现此目的。

#2

You can use a tool such as mysql workbench or phpmyadmin to create the dump. It will be a bunch of inserts as well as all the other data in it (such as procedures).

您可以使用mysql workbench或phpmyadmin等工具来创建转储。它将是一堆插入以及其中的所有其他数据（例如过程）。