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
5. Type \. c:\mysqlfile.sql to execute your sql file into the database.
should look like this
You can then check in PHPMYADMIN to make sure all the tables and data is correct.Posted by