How can I import a database using SSH?

Home » Knowledge Base » F.A.Q. » Database Management » How can I import a database using SSH?

You need to create an SSH account from your Control Panel > Hosting Tools > SSH Manager section.

Your database backup/dump can be imported using your configured SSH account by executing the following command through SSH:

mysql -h [DB HOSTNAME] -u [DB USERNAME] -p[DB PASSWORD] [DB NAME] < /home/www/database.sql

All the database settings – [DB HOST], [DB USER], [DB PASS], and [DB NAME] should be written exactly as they are displayed in your Hosting Control Panel > Database Manager section.

The dump file should be uploaded into your hosting account and the path /home/www/database.sql may vary depending on the place you uploaded the dump of your database. For example, if you have uploaded your MySQL dump file at /home/www/yourdomain.ext/backups/database.sql you should edit the command to look like this:

MySQL -h [DB HOSTNAME] -u [DB USERNAME] -p[DB PASSWORD] [DB NAME] < /home/www/yourdomain.ext/backups/database.sql

Note: You should make some slight modifications to your database.sql file prior to the import. You need to remove the CREATE DATABASE and USE commands at the first lines of your database.sql file. The lines in question are shown below:

−− CREATE DATABASE ‘username_db’ DEFAULT CHARACTER SET XXXX COLLATE XXXX;

−− USE username_db;

Was this post helpful?

i

Relevant tags:

Connect

Latest posts:

How to Remove a Product in OpenCart

After installing OpenCart and logging in to the dashboard, you can start adding and removing products immediately. We have already covered how to add products in OpenCart, and in this article, we share simple steps to delete products from your store with only a few...

How to Add Products in OpenCart

The most important element in your OpenCart project is the products you will offer your site visitors. In the following paragraphs, we share how to add products to your OpenCart website.   How to Create Products in Opencart The process of adding new products in...

How to Log in to OpenCart

After you install OpenCart, you can log in to the platform and start working on your project right away. To log in, you should open the OpenCart login page and enter the credentials you chose when installing the CMS. This will open the platform’s admin panel. In the...

How to Install OpenCart

You can install OpenCart on every AwardSpace web hosting plan, including our free web hosting, shared hosting, and advanced AwardSpace services such as Semi-Dedicated Hosting and VPS hosting. Keep in mind that all of the AwardSpace hosting services are tailored to run...

How to Change My Last Name in Moodle

If you are asking yourself "How to change my last name in Moodle", then you are at the right place. This guide will walk you through the steps for changing your last name in Moodle while addressing common concerns like ratings and discussions.   How to Change My...



Create a website for free!


Free forever

Our Support Team is Here to Help

 

If you need any questions answered, don't hesitate and contact us. Click the button below and follow the instructions. You can expect an answer within an hour.

 

Contact AwardSpace

 

iNewest knowledge base articles

How to Remove a Product in OpenCart

After installing OpenCart and logging in to the dashboard, you can start adding and removing products immediately. We have already covered how to add products in OpenCart, and in this article, we share simple steps to delete products from your store with only a few...

How to Add Products in OpenCart

The most important element in your OpenCart project is the products you will offer your site visitors. In the following paragraphs, we share how to add products to your OpenCart website.   How to Create Products in Opencart The process of adding new products in...

How to Log in to OpenCart

After you install OpenCart, you can log in to the platform and start working on your project right away. To log in, you should open the OpenCart login page and enter the credentials you chose when installing the CMS. This will open the platform’s admin panel. In the...

How to Install OpenCart

You can install OpenCart on every AwardSpace web hosting plan, including our free web hosting, shared hosting, and advanced AwardSpace services such as Semi-Dedicated Hosting and VPS hosting. Keep in mind that all of the AwardSpace hosting services are tailored to run...

How to Change My Last Name in Moodle

If you are asking yourself "How to change my last name in Moodle", then you are at the right place. This guide will walk you through the steps for changing your last name in Moodle while addressing common concerns like ratings and discussions.   How to Change My...

How to Change Your Name in Moodle

Changing your name in Moodle is a very simple task and requires only a few minutes of your time.   How to Change My Name in Moodle The process is comprised of a few easy-to-follow steps:   Step 1: Log in to Moodle After installing the CMS, you should log in...

Even more web tutorials

Check out our web hosting knowledge base and the WordPress tutorials to learn more, and be better prepared for your website creation and maintenance journey.