How to generate whole sql database script in MySql Workbench
I have a MySql database in local my computer, today I want to export the whole have in that database to run it on another server.
I try select and export all tables as below:
But with this way, I only can export script sql to create all tables, not have data of those tables, no views, no functions, no store procedures...
How to generate the whole SQL database script in MySql Workbench 8.0?
Thanks for any solution!!!
Tuấn Dương Anh Feb 25 2022
If you use MySql workbench 8.0, you can generate the whole database as below:
1. Log in to the database you want to export
2. In the menu select Server -> Data Export
3. Select the database you need to export as the image below
I hope it's useful for you