Import database using command line (on Windows)

1. Open command line windows (C:\windows\system\cmd.exe)

2. type: mysql -u [{username}] -p [{password}]
Ex: mysql -u [root] -p []

3. type: cd {my_sql_path}\bin
Ex:
cd C:\xampp\mysql\bin

4. type: use {database name}
Ex:
use demo_db

5. type: \. {sql_file_path}
Ex: \. C:\demo.sql

Comments
My Cart
loading