I have 6 tables already created, which I access from mySQL Workbench. Is there any way I can get the query for the creation of the database and all 6 tables inside it? I need this so that I can create that database and all 6 tables on it, on another computer simply by double clicking an sql file. Thanks in advance :)
5
-
2export it as .sql filemomouu– momouu2016-01-05 01:57:51 +00:00Commented Jan 5, 2016 at 1:57
-
And import it to your other computer.Logan Wayne– Logan Wayne2016-01-05 02:02:34 +00:00Commented Jan 5, 2016 at 2:02
-
@monace19 export to dump project folder or self-contained file?Programmer– Programmer2016-01-05 02:03:27 +00:00Commented Jan 5, 2016 at 2:03
-
2Welcome to StackOverflow. Check the StackOverflow's help on asking questions first, please. Focus on How to ask a good question and How to create a Minimal, Complete, and Verifiable example, but also other help topics would be useful.David Ferenczy Rogožan– David Ferenczy Rogožan2016-01-05 02:06:29 +00:00Commented Jan 5, 2016 at 2:06
-
This could help I think. dev.mysql.com/doc/workbench/en/…momouu– momouu2016-01-05 02:13:12 +00:00Commented Jan 5, 2016 at 2:13
Add a comment
|
1 Answer
If you want to get SQL File from MYSQL Workbench, you need to do this :
- Open your model.
- Click Database menu and choose Forward Engineer.
- And click next until you show like picture below,
- Save to file..
3 Comments
Programmer
Where is forward engineer? I only see reverse engineer.
Programmer
@EkoJunaidiSalam 6.3.3.0 and I'm on Mac OSX
Programmer
@EkoJunaidiSalam Thanks! I didn't create the model, that's why. I created it, forward engineered, and now I have the sql file. Thanks very much. By the way, I have to create the connection manually though on my other computer right?