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
This question is related to
mysql
mysql-workbench
You can do it using mysqldump tool in command-line:
mysqldump your_database_name > script.sql
This creates a file with database create statements together with insert statements.
More info about options for mysql dump: https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html
For the latest version of MySql Workbench
In MySQL Workbench 6.1
.
I had to click on the Apply changes
button in the insertion panel (only once, because twice and MWB crashes...).
You have to do it for each of your table.
Generate INSERT statements for table
Go to Menu Server and Click on Data Export. There you can select the table and select the option Dump Structure and Data' from the drop-down.
Source: Stackoverflow.com