Importing Databases via SSH

Here is a quick explanation of how to import a MySQL database that has been dumped into a text file.

1. Create a new database and mysql user in Cpanel. Refer to our Cpanel documentation for more info. Make sure the user has full permissions on the database.

2. Upload your sql file via FTP to the root of your account.

3. Login via SSH and enter the following command...

mysql -u USER -p DBNAME < dump.sql

Where USER is the database user you created, DBNAME is the name of the database you created and dump.sql is the name of the file you uploaded.

Was this answer helpful?

 Print this Article

Also Read

How to Change your cPanel Password

There are two ways to change your cPanel password. The easiest way to do this is from inside your...

General FTP Guide

FTP stands for File Transfer Protocol and actually refers to the method of transport rather than...

Creating Email Accounts

To create an email account in your UK Web Hosting plan, you first need to be logged into your...

How do I get SSH Access?

By Default, Secure Shell Access is disabled on all accounts. If you require SSH access enabling...

Images Not Showing

You may have created the link to call the image on your page, but the image has not been...