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.
No Comments »
RSS feed for comments on this post. TrackBack URL

