Executing a very large .sql file from mysql command line

Today, I finally managed to get this to work.

I am working on a Windows 2008 server using Wamp with mysql 5.5.24.

On my server, I opened a command window and changed to mySQL directory

c:\wamp\bin\mysql\mysql5.5.24\bin

I created a mysql session by issuing the following command from the DOS prompt

c:wamp\bin\mysql\mysql5.5.25\bin> mysql  -u  username -p dbname

I was prompted for the password for the username supplied.

The mysql> prompt and a MySQL connection id indicates a session has begun.

Typing \s at the mysql> prompt provides information about the session

With a connection made, and a database selected, I used this command to run my .sql file.

mysql> source pathtofolder\filename.sqlsource

  

 

This command executed  the 240 MB .sql file, restoring my entire moodle database in about 2 minutes! The GUIs (phpmyadmin, MySQL Workbench) took much much longer and required me to break the file into multiple files.