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

Old Pages At My Site

If you have updated your website but you still see the old pages, double check that you uploaded...

My Site Displays "Index Of"

This is caused by not having a home page file inside your public_html folder - named...

How to Login to cPanel

Your UK Web Hosting account comes with the industry leading control panel cPanel. When you sign...

How do I get SSH Access?

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

Uploading to an Addon Domain

To upload to an addon domain with an FTP client you have 2 options : 1. login via FTP to your...