Export DataBase with MySQL Workbench with INSERT statements

mysql mysql-workbench
Alvaro picture Alvaro · Nov 6, 2012 · Viewed 117.8k times · Source

I am trying to export the DataBase i have at MySQL Workbench but I am having troubles to generate the INSERT statements on the .sql file.

I order to export the data, I do the reverse engineering for the database i want to export. Then, i go to

File / Export/ Forward Engineer SQL CREATE Script

And once in there, i select the option Generate INSERT Statements for Tables.

The result only generates the code for the create tables.

Is there any way to create the insert statements for the data?

Thanks

Answer

Vardan Gupta picture Vardan Gupta · Nov 6, 2012

For older versions:

Open MySQL Workbench > Home > Manage Import / Export (Right bottom) / Select Required DB > Advance Exports Options Tab >Complete Insert [Checked] > Start Export.

For 6.1 and beyond, thanks to ryandlf:

Click the management tab (beside schemas) and choose Data Export.

Related questions

MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. I'm writing the following command: UPDATE tablename SET columnname=1; It gives …

Read More
MySQL: How to allow remote connection to mysql

I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect from external source. How can I do that?

Read More
Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges?

I am continuously receiving this error. I am using mySQL Workbench and from what I am finding is that root's schema privileges are null. There are no privileges at all. I am having troubles across platforms that my server is …

Read More