Import mysql DB with XAMPP in command LINE

Question

I have this below command:

mysql -u #myusername -p #mypasswd MYBASE < c:\user\folderss\myscript.sql

Though, I get the below error while executing:

Error
unknow command '\U'
unknow command '\m'
unknow command '\D'
unknow command '\L' 

Answer 1

For those using a Windows OS, I was able to import a large MySQL dump file into my local XAMPP installation using this following command in the command prompt.

C:\xampp\mysql\bin>mysql -u {DB_USER} -p {DB_NAME} < path/to/file/ab.sql

Want to become an expert in SQL? Join SQL Certification course fast !!

You can also watch the below MySQL video tutorial for much deeper understanding.