Restoring a database backup to a local machine in MySQL

Question

I have downloaded my .sql file of my database server. It is in the D: drive of my Windows machine.

I want to restore the back up in my this machine. I used:

mysql database -u root < backupfile.sql

Where database is my new database name in this machine. My confusion is that my backupfile.sql is in the D: drive and thus I guess there is error.

ERROR 1064 <42000>:You have an error in your SQL syntax;Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql database -u root < backupfile.sql' at line 1.

Answer 1

You should login to mysql like this

C:\> mysql -uroot -p <hit enter>
Enter password:

Next, select the database you want to load the data into

mysql> CREATE DATABASE IF NOT EXISTS mynewdb;
mysql> USE mynewdb

Then, run the script

mysql> source D:\backup\backup.sql

Give it a Try !!!

Answer 2

You should pass full path of .sql file like where it resides ex : "D:\file_name"

Try this one

 mysql -u YourUser -pYourPassword DBName < D:\backupfile.sql