Restoring a database backup to a local machine in MySQL
You should login to mysql like this

C:\&gt; mysql -uroot -p &lt;hit enter&gt;
Enter password:


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

mysql&gt; CREATE DATABASE IF NOT EXISTS mynewdb;
mysql&gt; USE mynewdb


Then, run the script

mysql&gt; source D:\backup\backup.sql


Give it a Try !!!