Import MySQL Dump file using MySQL Command Line tool in windows 10

 

It really pain and may be you are facing same kind of issues which i faced so far to import mysql dump file using MySQL Command line tool in windows 10. 

You will be able to find multiple posts about SOURCE command you need to use but here certain things which might you also not able to find and still struggling with proper information. 

So easy solution here is : 

mysql> use db_name;

mysql> SET autocommit=0 ; source the_sql_file.sql ; COMMIT ;

But few catches here : 

First Catch : 

Just use the absolute path of the file and then, instead of using backslashes, use forward slashes.
Example:
with backslashes : source C:\folder1\metropolises.sql
with forward slashes : source C:/folder1/metropolises.sql


Second Catch : 
 filename must not be in quotes even if it contains spaces in name or path to file.