Dumping into MySQL in Windows

I had a 300mb SQL file I needed to dump into MySQL in Windows (running XAMPP).

1. Open a command line (start > run > cmd)

2. Navigate to c:\xampp\mysql\bin

3. Enter: mysql -uroot (or whatever username you have – use -p for password).

4. Change to the database you want to import into

USE databasename

press enter

5. Type \. c:\mysqlfile.sql to execute your sql file into the database.

should look like this

mysql>\. c:\mysqlfile.sql

You can then check in PHPMYADMIN to make sure all the tables and data is correct.

Leave a Reply