How do I open a MySQL Database Dump?
Although there are a number of tools out there, I prefer the command line for tasks such as this. Better performance, and just simpler.

Make sure you're logged into the mysql client:

mysql -u &lt;username&gt; -p


The first step is to create a database in mysql that you want the data in:

CREATE DATABASE &lt;database name&gt;;


Then you need to open--or use--that new database, which is empty:

USE &lt;database name&gt;;


All that's left is to do the import:

\. /path/to/file (or if in Windows, \. C:\PATH\TO\FILE)


If all goes well, you'll see a bunch of output about "Query successful, N rows affected" and so on.