Includes free SSL certificate, unlimited bandwidth & fully optimised for WordPress.
Fully PCI-DSS compliant hosting, backups every 6 hours & free DDoS protection.
Unlimited bandwidth, WHM & cPanel control panel & fully white label.
Great value domain names available.
Create a professional looking website in minutes. Over 190 templates.
Speed up the delivery of your site.
Beautifully Simple. Massively Configurable. Scales from 1 VPS cloud, all the way up to a load balanced cluster.
Fully managed, high-spec dedicated servers deployed on our gigabit network, backed by our superior 24/7 UK support.
Instantly talk to one of our support team, we're here to help.
For our clients only. Open a ticket you can track and reply to.
Monday–Friday 9am – 8pm we're ready to assist you.
We pride ourselves on offering a hosting support service like no other; polite, knowledgeable & fast.
This article will show you how you can import MySQL databases that are too large to upload reliably using the phpMyAdmin tool included in cPanel. Uploading a large database via phpMyAdmin can take a long time, and a dropped connection or other issue can be very frustrating. In cases like this it is better to import the database manually using an SSH (Secure SHell) session.
In order to connect using SSH, please firstly read the article How to install PuTTY for SSH shell access. Then connect to your server using SSH. The rest of this article assumes you have successfully opened an SSH session.
Importing your database
In order to import your database you will need to have the following information to hand:
Here is an example command :
mysql -u krystald_myuser -p krystald_mydata < mydumpfile.sql
Just substitute in your MySQL database name, username, and dumpfile name and enter the command! When you hit you will be promted to enter the password for the database user. Just enter it (it won't echo to the screen) blindly and press again to start the import.
Restoring a large database with thousands of hundreds of thousands of rows might take a minute or so to restore, so be patient or go and make a pot of tea - it WILL finish eventually.
What can go wrong
Not much really, but if the import fails or does not complete due to errors, it's easiest just to delete the database from within cPanel (assuming you don't need it!), and recreate an empty one and try again.
A common problem with importing mysql files can occur if the dump file includes instructions to CREATE or USE a particular database name. If such instructions exist (and they will be at the top of the file if anywhere), then either comment them out (by inserting two hyphens -- at the start of each line) or remove them.