Generate Mysql Workbench Script

Question

Good afternoon.

I use Mysql Workbench 6.3. I need to generate the script to create the local database to publish on the server. It is completely impossible to create everything again in the hand because the base is huge.

How can I do this??? Generate a script to create the database??

Answer 1

There is this simple procedure Database Export via Mysql Workbench where you export your bank using the Data Export and a file is generated in the place where you inform.

Procedure

---

1 - Access the Mysql Workbench and start connection to the database;

2 - When accessing the Bank, go to the "Management" on the left side of the program and click on the option "Data Export";

3 - Then, on the screen that appears, do the following procedures:

3.1 - Select the Database you want to export;
3.2 - check his tables on the right side;
3.3 - Check the option "Dump stored Procedures and Functions";
3.4 - Check the option "Dump Events";
3.5 - Check the option "Export to Self-contained File";

Select the location where you want to save the database by clicking on 3 dots button (...). Don’t forget to name the file of the Bank (In doing so check if the path and name are correct in the field of locality);

Finally, click on "Start Export".