Import-Export Database (For Windows)

To Import Database using MySQL Console: (For Windows)

mysql> show databases;

mysql> USE database_name;

mysql> SOURCE D:\backup\subsite1700.sql

To Export Database using Command Prompt: (For Windows)

D:\wamp\bin\mysql\mysql5.5.8\bin>mysqldump -u root -p database_name > d:/db_backup.sql

After writing above command when you press Enter, it asks for the Password.
Press Enter if you have no password set for the root user. Otherwise enter the password and press Enter.


Another Way to Import :

First go to 
D:\wamp\bin\mysql\mysql5.5.8\bin>
Using Command Prompt

After Then Fire below command:
mysql -u root -p subsite < d:\sales_flat_quote.sql