Questions? Feedback? powered by Olark live chat software
Knowledgebase
Author Avatar

Importing a Large MySQL Database

Written by: on 26 May 2016 11:20 PM 26 May 2016 11:20 PM

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

(0 vote(s))
Helpful
Not helpful