Database - Create, Import or Export a Database in cPanel

  Print

How to Create, Import or Export a Database in cPanel


These guides assume you've logged into cPanel.


How to Create a Database using MySQL Database Wizard
Step 1
- Open the MySQL Database Wizard.

mysqlwizardpic1.png











Step 2 - Name your database and hit Next Step. Your database's name will always start with cpanelusername_
mysqlwizardpic2.png











Step 3 - Create a user for the database. Again this will start with cpanelusername_ automatically. For the Password, we recommend using the password generator to create a secure password, . Make sure you copy the password and username somewhere safe on your computer. Once done, select Create User.

mysqlwizardpic3.png











Step 4 - Select the user's privileges then click Next Step. If this is the main user for this database you will want to select All Privileges.

mysqlwizardpic4.png











Step 5 - The database is now created. Select Return Home.

mysqlwizardpic5.png

How to Import a Database using PHPMyAdmin

Note: 
PHPMyAdmin has a upload file size limit of 50MB. If your database is larger than 50MB, we would recommend following this guide to import the database via SSH. If required, you can also upload the database to your File Manager and then reach out to our support staff for assistance with importing it.


Step 1 - Open the phpMyAdmin tool.

dbexportpic01.png










Before you read this, ensure you have a blank database created. This needs to be done before you import data. If you have used Softaculous to install a CMS like Wordpress or Joomla, the database would have been created as part of the installation process.

Step 2 - Select the correct database from the left panel

mysqlimportdbphpmyadminpic2.png











Step 3 - Click the Import button.

mysqlimportdbphpmyadminpic3.png











Step 4 - Select the database you wish to upload.

mysqlimportdbphpmyadminpic4.png











Step 5 - Click Go.

mysqlimportdbphpmyadminpic5.png












How to Export a Database using PHPMyAdmin

Step 1 - Open the phpMyAdmin tool.

dbexportpic01.png


Step 2 - Select the correct database from the left panel
7986663dc11b6ea45fee0b405a230260e122e3eac85c8338160078f0028579f3b2fedaaeac56a424?t=738cd32799b4f9e33c47b2712dfe949a






Step 3 - Navigate to the Export button, then click Go.
3dac97575832f7deef29d959f362f6c3a249a45786db19d7cd1c079182c8ad26b9a99dbd25212c6f?t=53dc4fed45a8397313d83b93200ec9ea






How to Export a Database using the cPanel Backup tool

Step 1 - Open the Backup tool.
2b4c0b0de1c27332fc01a8835919c4144b3d75cc499fbe1a407dbf3ba54c3a0b17560165ff2ed489?t=d203148625f910e44e94654b2196a335






Step 2 - Navigate to the Download a MySQL Database Backup utility then click on the database name to start a download.dab53fe7caed3e459a268f16847cbc191b3b5c3f0aad7b2117c09af23656ececc4353c3da3d3fe4c?t=14bcfc2be505439ae0b3465dc74119b7






How to Import a Database using the cPanel Backup tool

Step 1 - Open the Backup tool.
2b4c0b0de1c27332fc01a8835919c4144b3d75cc499fbe1a407dbf3ba54c3a0b17560165ff2ed489?t=d203148625f910e44e94654b2196a335






Step 2 - Navigate to the Restore a MySQL Database Backup utility, browse for the database on your local device and click upload.26e0e916b2521a075dc9e1df5297b4597b95f38724d441fb77613897ddca4b6f39254ead2b9d6ac6?t=817576b86ac13bdd0e8e12dcc29b5484








Did you find this article useful?  

Related Articles

© Crucial