MySQL workbench : How to export mysql database to .sql file?

In MySql Workbench version 8.0 you can just follow the next steps

  1. Go to Server tab
  2. Go to Database Export

This opens up something like this

MySQL Workbench

  1. Select the schema to export in the Tables to export
  2. Click on Export to Self-Contained file
  3. Check if Advanced Options… are exactly as you want the export
  4. Click the button Start Export

Leave a Comment