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:
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:
mysql -u username -p database_name < dumpfile.sql
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.
The best way to import a huge MySQL database is using SSH access with the web hosting account. This should be available with SiteServing.Posted by Richard - Wed, Jul 4th, 2012 11:50 AM