Export DataBase with MySQL Workbench with INSERT statements

Question

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

User · Answer

For the latest version of MySql Workbench   Click on the Server menu in the top menu bar Select  Data Export  submenu It will open up the Object Selection window where you can select the appropriate database which has the desired tables Once you select the database in the left side all the tables will appear in the right side with radio buttons Select the radio buttons in front of needed tables Just below the table selection you can see a dropdown to select Dump Structure Only or Data only or Structure  amp  Data Under Objects to Export tick the box if you need stored procedures or events also  If you don t need those then untick those Under export option change the exporting file name and path If you want to create the schema once you import the dump file then tick include create schema Press Start Export button in the right-hand side corner  once it successful the summary will be showing in the Export progress tab

User · Answer

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

User · Answer

You can do it using mysqldump tool in command-line   mysqldump your database name  gt  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

User · Answer

I had some problems to find this option in newer versions  so for Mysql Workbench 6 3  go to schemas and enter in your connection       Go to Tools -  Data Export      Click on Advanced Options      Scroll down and uncheck extended-inserts      Then export the data you want and you will see the result file as this

User · Answer

If you want to export just single table  or subset of data from some table  you can do it directly from result window   Click export button    Change Save as type to  quot SQL Insert statements quot

User · Answer

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     Then export your schema      Check Generate INSERT statements for table    It is okay

User · Answer

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

[mysql] Export DataBase with MySQL Workbench with INSERT statements

Examples related to mysql

Examples related to mysql-workbench