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:
- Access to command line (DOS), and
- WAMP
Note: the following examples assumes you have WAMP installed in c:\wamp and your SQL dump is in c:\dump
- First, launch command prompt via All Programs -> Accessories -> Command Prompt.
- 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 - Lastly, run the following:
mysql> source c:\dump\my_database_dump.sql