Importing a MySql Database

You can import a MySQL database via phpMyAdmin which is available in the cPanel control panel. If you haven't yet created a database to import your database to and you are unsure how to do this, please read the following help article - [Creating a MySql Database](https://hostpresto.com/help/article/11/). * * * The first step is to log into your cPanel account. If you are unsure on how to do this, please view the following help article - '[How to log into cPanel](https://hostpresto.com/help/article/1)'. ![alt text](https://i.imgur.com/QRmld56.png "Import MySql database 1") * * * Scroll down to the '**Databases**' section and choose '**phpMyAdmin**'. ![alt text](https://i.imgur.com/fDFcePV.png "Import MySql database 2") * * * Once phpMyAdmin has loaded, from the left hand side, you should see your account name. Click on the '+' icon to expand the available databases on your account. ![alt text](https://i.imgur.com/VEtJmKM.png "Import MySql database 3") *** **Choose the database** that you wish to import your database to from the same left hand side menu. ![alt text](https://i.imgur.com/vA8kYSY.png "Import MySql database 4") * * * Once the database has loaded, select the '**Import**' menu option from the top navigation. ![alt text](https://i.imgur.com/8GSZps8.png "Import MySql database 5") * * * In the '**File to Import** section, select '**Choose File..**' and locate the database file on your system. > Please note - there is a maximum file size limit but this will be shown next to the 'Browse..' section. You may need also to customise the rest of the options in this section depending on what you are intending to import and the file format. ![alt text](https://i.imgur.com/YzTLUkc.png "Import MySql database 6") * * * Once the file to be imported has been chosen (and any other options configured), select the '**Go**' to start the import. ![alt text](https://i.imgur.com/uOnfaeX.png "Import MySql database 7") * * * Once the database import is complete, in our case a new table has been imported, you should see the available table on the left hand side. If you are importing data to a table that already exists, select your table and review the records. ![alt text](https://i.imgur.com/OZmCvPN.png "Import MySql database 8") Importing a MySQL database via phpMyAdmin is now complete. ***
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to log into cPanel

There are two different methods to log into your cPanel control panel in order to manage every...

What's the difference between Aliases, Addon and Subdomains?

### Aliases An Alias domain does not have a unique website. It is a domain that is masked to...

Creating a MySql Database

If your website uses PHP or you need to hold a collection of records which need to be accessed...

Exporting a MySql Database

You can export a MySQL database via phpMyAdmin, available in cPanel, if you want to keep a backup...

Viewing your Web Stats

Web Stats for your website are important to determine everything about the visitors to your...