How to import a database using phpMyAdmin?

Home » Knowledge Base » F.A.Q. » Database Management » How to import a database using phpMyAdmin?

Log into phpMyAdmin from your Control Panel -> Website Manager section using your Database Username and Database Password. Once you are inside the phpMyAdmin click the import button and select the database which you would like to import.

Note: You might have to 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;

Note: If your database backup/dump is too big and you are unable to import it using phpMyAdmin, try importing it via SSH.

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.