Chat with us, powered by LiveChat

How can I import a database?

You can import your database in one of several ways.

This FAQ assumes you have already exported your database into an SQL file or a gzipped file.  If you have questions about how to export your database you can click here.

Option 1 via phpMyAdmin:
You will need to log into your cPanel control panel by visiting http://yourdomain.com/cpanel
First, make sure the database you want to import into has already been created.  If not, you can create a fresh database by clicking on the MySQL Databases icon in cPanel and creating your database there.

If you have already created your database or have an existing one, you’ll want to click the phpMyAdmin icon from the cPanel homepage.  Next, click on the Import tab.  From there you can click Browse and browse to your SQL file and start your upload.

Option 2 via SSH:
If you are familiar with SSH, you can log into your server via SSH and upload your database using the following command:

mysql -u dbusername -p dbname < filename.sql

Here, you’ll want to replace dbusername with your database username, and dbname with your database name.  filename.sql is the name of your SQL file that you would like to import.

Option 3 via Ticket:
Larger databases may require the assistance of one of our technicians.  If you experience any issues importing your database, feel free to submit a ticket for assistance.  You can either upload your SQL file via FTP or we can provide you instructions on how to send us your database and we can import it for you.  You can submit a ticket at anytime by visiting https://secure.hostduplex.com/clientarea.php