MySQL workbench : How to export mysql database to .sql file?
49,228
Solution 1
try this and select export to self constrained file .sql along with the path.
Solution 2
In MySql Workbench version 8.0 you can just follow the next steps
- Go to Server tab
- Go to Database Export
This opens up something like this
- Select the schema to export in the Tables to export
- Click on Export to Self-Contained file
- Check if Advanced Options... are exactly as you want the export
- Click the button Start Export
Related videos on Youtube
Author by
strange_098
Updated on July 09, 2022Comments
-
strange_098 almost 2 years
I need to export my database in mysql workbench to a file .sql.
What to do?
Can anyone help me please?
Thanks and regards
-
mamdouh alramadan about 10 yearspossible duplicate of How to generate the whole database script in MySQL Workbench?
-