How to import an SQL file by using mysqldump on Windows through command line

Question

How do I import an SQL file to MySQL dump using command line. I am using windows.

Answer 1

Navigate to the directory where you have mysql and issue this command, changing the bold values to your file/database locations.

c:\mysql\bin\> mysql -u USERNAME -p PASSWORD database_name < filename.sql

Answer 2

Simple steps to import sql file.

Click on WampServer and then go to MySQL=> MySQL console enter password \If no password click simply enter create database database_name; \If database already there skip this step use database_name; source D:\backup.sql \Path of database file