Exporting tables using MySQL Workbench with INSERT statements

Question

I am trying to export a DataBase to my MySQL Workbench, but I am having problems creating INSERT statements in a .sql file.

I want to export data, I am doing reverse engineering for the database I want to export. Then, let's move on to

File / Export / Forward Engineer SQL CREATE Script

And once there, I select the option Generate INSERT statements for tables .

The result only generates code for the create tables.

Can I create insert statements for data?

thank

Answer 1

For older versions:

Open the MySQL Workbench> Home> Import / Export Management (bottom right) / select the DB you want> Advanced Export Options tab> Paste [Checked]> Start Export.

---

For 6.1 and above, thanks to ryandlf:

Go to the management tab (next to the diagrams) and select "Export Data."

Answer 2

You can do this using the mysqldump tool on the command line:

mysqldump your_database_name > script.sql 

Creates a file with instructions for creating a database along with insert instructions.

More details about mysql dump options: https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html

Answer 3

In MySQL Workbench 6.1 .

I had to click the Apply changes button on the input panel (only once, because twice and MWB failed ...).

You must do this for each of your tables .

Then export your schema:

Check Generate INSERT statements for table

Everything is fine!

Answer 4

I had problems finding this option in new versions, so for Mysql Workbench 6.3 go to the schemas and enter into your connection:

---

Go to Tools → Export Data

---

Click Advanced Options

---

Scroll down and uncheck extended-inserts

---

Then export the data you need and you will see the result file as follows:

Answer 5

Go to the "Server" menu and click "Export Data." There you can select the table and select the "Dump structure and data" option from the drop-down list.