33

I need to export my database in mysql workbench to a file .sql.

What to do?

A-Sharabiani
  • 17,750
  • 17
  • 113
  • 128
strange_098
  • 1,261
  • 6
  • 24
  • 44
  • possible duplicate of [How to generate the whole database script in MySQL Workbench?](http://stackoverflow.com/questions/4930733/how-to-generate-the-whole-database-script-in-mysql-workbench) – mamdouh alramadan Mar 13 '14 at 14:25

2 Answers2

57

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
Tiago Martins Peres
  • 14,289
  • 18
  • 86
  • 145
37

try this and select export to self constrained file .sql along with the path.

enter image description here

Divya
  • 1,469
  • 1
  • 13
  • 25