Export DataBase with MySQL Workbench with INSERT statements

Solution 1:

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.

Solution 2:

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:

Solution 3:

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