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

Question

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

What to do?

possible duplicate of How to generate the whole database script in MySQL Workbench? — mamdouh alramadan
– mamdouh alramadan, Commented Mar 13, 2014 at 14:25

Tiago Peres · Accepted Answer · 2020-03-29 10:16:26Z

77

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

This opens up something like this

answered Mar 29, 2020 at 10:16

Tiago Peres

15.9k22 gold badges104 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Divya · Accepted Answer · 2014-03-13 15:15:19Z

38

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

enter image description here

answered Mar 13, 2014 at 14:54

Divya

1,4851 gold badge13 silver badges25 bronze badges