SQL restore question
A while ago I made a machine switch. Using Navicat I exported my database to a .sql file. I just finished getting everything reworking, and built. I was wondering how you restore your db from a sql file? I just hope I didn't do it wrong :shock:
|
Found the answer
Found the answer to my own question:
mysql -h localhost -u [MySQL user, e.g. root] -p[database password] [name of the database] < [name of your sql dump, e.g. sqldump.sql] worked like a charm, just in case anyone else ever wonders :-). Now I can get to work! |
Or, in Navicat, you can create the database you want to use and right click that database and select "Run Batch File". That will do the same thing.
|
All times are GMT -4. The time now is 06:35 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.