How to import a large SQL dump into WAMP

Recently I had to import a 3GB database into a local Drupal installation using WAMP in a Windows XP environment. The following method I found has consistently performed and requires very minimal setup.

All you need are:

  1. Access to command line (DOS), and
  2. WAMP
Note: the following examples assumes you have WAMP installed in c:\wamp and your SQL dump is in c:\dump
  1. First, launch command prompt via All Programs -> Accessories -> Command Prompt.
  2. Then run the MySQL command below to connect to your specified database:C:\> c:\wamp\bin\mysql\mysql5.5.16\bin\mysql.exe -use databasename –u username -p password
  3. Lastly, run the following:mysql> source c:\dump\my_database_dump.sql