Good afternoon.
I use MySql Workbench 6.3. I need to generate the script to create the local database to publish to the server. It is completely impractical to create everything again in the hand because the base is huge.
How can I do this ??? Generate a script to create the database ??
This is a simple procedure Bank Export via MySQL WorkBench where you export your bank using Data Export and a file is generated in the location where you inform. Procedure
The first step is to access MySQL WorkBench and start the connection to the Database.
When accessing the Bank, go to the "Management" tab on the left side of the program and click on the "Data Export" option
Then, on the screen that appears, do the following:
Select the database you want to export; Then check his tables on the right side; Check the option "Dump stored Procedures and Functions";
Check "Dump Events";
Check the "Export to Self-Contained File" option and then select the location where you want to save the Bank by clicking the 3-dot button (...). Do not forget to give a name to the Bank file. When doing this make sure the path and name are correct in the location field;
When you do everything click "Start Export".
