MySQL Workbench Rebuidling Database From Script File

Question

I have a script file that has a bunch of create commands, and one that has a bunch of inserts. I would like to use these commands to rebuild my database on a different PC but I am struggling with how to accomplish this.

I just installed a fresh copy of MySQL Workbench and I created a new Model. Now what?!

Thanks for the help!

What is the format of the script? You should be able to just open the script file and then run the script as a query. — zero298
– zero298, Commented May 6, 2014 at 20:07
It is a .sql extension. So I should connect to the database and then in the query window I can copy/paste the code? — Talen Kylon
– Talen Kylon, Commented May 6, 2014 at 20:08
Yes, connect to the DB, load the file via either copy/paste or open it as a file, then run query. I'll post an answer with screenshots. — zero298
– zero298, Commented May 6, 2014 at 20:10

zero298 · Accepted Answer · 2014-05-06 20:17:22Z

1

You should be able to rebuild your tables from the script

First, connect to the database

Connect to database

Then, open your script file

Open the script

Run the query

After that, you should have your tables restored.

answered May 6, 2014 at 20:17

zero298

27.1k10 gold badges80 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL Workbench Rebuidling Database From Script File

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related