How to generate whole sql database script in MySql Workbench

Dung Do Tien Feb 25 2022 37

Hi Guys,

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:

How to generate whole sql database script in MySql Workbench?

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!!!

Have 1 answer(s) found.
  • T

    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

    How to generate whole sql database script in MySql Workbench

    3. Select the database you need to export as the image below

    How to generate whole sql database script in MySql Workbench

    I hope it's useful for you

Leave An Answer
* NOTE: You need Login before leave an answer

* Type maximum 2000 characters.

* All comments have to wait approved before display.

* Please polite comment and respect questions and answers of others.

Popular Tips

X Close