Oct
21
2008

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.

Written by Pete in: Uncategorized |

No Comments »

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress | Aeros Theme | TheBuckmaker.com WordPress Themes