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 a database from a file on your local computer to your Krystal cPanel account. This article assumes that you are already successfully logged into cPanel.
Step 1 - Create a database if you have not already done so
Before you can import a database dump file from your computer, a destination database must already exist within your cPanel account. Please see the article How to configure MySQL databases in cPanel.
Step 1 - Open the phpMyAdmin web application
Open the phpMyAdmin web application by clicking on the phpMyAdmin icon in the Databases section of cPanel.
Step 2 - Select your database
Once phpMyAdmin opens, you will see down the left margin a list of databases to which you have access. information_schema is a special database that holds information "about" your databases - you do not need to access this.
Click on the name of the database you want to import your data into - in the below case, krystald_testing.
Step 3 - View Import settings
Click on the Import tab.
Step 4 - Import your data
Step 5 - Any Errors?
A common error that occurs looks like the one shown below. This is because your database dump file contained instructions to create a specific database name. This is not allowed, because we are importing data into a known (predefined) database. To prevent this error re-occuring you must comment out or remove the lines that are highlighted (in this case, remove the line that reads CREATE DATABASE etc..)