Import SQL File into MySQL

When moving my wordpress over to Windows I spent a little time finding out how to import a SQL dump file in to MYSQL. I didn’t find thing concrete that worked. So I used that feature, Help! and worked it out. Here are the steps I used.

1. Open MySQL Command Line Client and enter your MySQL root password
2. Select a database to import your SQL file too. Replacing “databasename” with your database name.
USE "databasename"

replacing “databasename” with your database name. Replace “C:\sqlfilenamee.sql” with the location of your SQL file.
3. Excute your SQL file by entering the following command
\. "C:\sqlfilenamee.sql"

Hit enter and your SQL file will be imported in to your database. Simples!