Learn how to import a large MySQL database today online. An exceptional online selfhelp tutorial. Learn Step by Step.
If you have a large MySQL database you need to import, you cannot import it via PHPMyAdmin as there is a 2MB limit.
Upload your database file (WinSCP is a great program for transferring files to a Linux server, grab it at: http://winscp.net/eng/index.php)
Login to SSH (we recommend using Putty)
Find your uploaded database file and enter the following command (entering the correct database name and sql dump file name and location):
mysql -u root -p DATABASENAME < SQLDUMPFILE.sql
If you have uploaded a ZIP of your MySQL dump, you can unzip it first with the command:
unzip FILENAME.zip
