How do I Import large databases into my web hosting account?

When it comes time to import a large database into your web hosting account, there are a couple of things that you should check on and be certain of before the import. These steps are outlined below:

• How large is the web hosting databases?
• What version of the database did it come from?

Once you have the above answered and the answer is that the database is less than 2GB in size, and the previous web hosting provider had it on MySQL 5.x minimum then you can easily import the database using SSH (secure shell) access. To do this, please follow the step-by-step guide outlined below:

• Login to your web hosting account via FTP
• Upload your .sql file into your home directory
• Then, login to SSH using your web hosting login
• Go to the folder where your .sql file is located
• Run the following command within SSH:

  mysql -u username -p database_name < dumpfile.sql

• Please remember to replace the "username" and "database_name" with the correct database information that you have setup to import this .sql file. Please note, you will be asked for a password as well when doing the import. The password is the same password you used when you created your MySQL database within your web hosting account.

Once you have completed the aforementioned steps, you should be all set with the database import. This is the suggest way of importing databases, as you can be assured that the database will import correctly and almost always without errors.

If you have any further questions, please feel free to reach out to our web hosting support team for further assistance on this issue.