How to import or export a MySQL database using phpMyAdmin

To make it easier to get in touch with us, from the 24th of March 2016 all support tickets will need to be submitted from your Crucial Control Panel.

 

 

 This guide is split into 2 parts:

 

How to Import a Database using PHPMyAdmin

Before you read this, click here for a tutorial on creating MySQL Databases. 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 1 - Log into cPanel

 

Step 2 - Click on phpMyAdmin

 dpimpextP01.png

 

 

Step 3 - Select the correct database from the left panel

 

dpimpextP02.png

 

Step 4 - Click the Import button

 

dpimpextP03.png

 

Step 5 - Select the database you wish to upload

 

dpimpextP04.png

 

6 - Click Go!

 

 

 dpimpextP05.png

 

 

How to Export a Database using PHPMyAdmin

Step 1 - Log in to cPanel

 

Step 2 - Click on the PHPMyAdmin icon

 

dpimpextP06.png

 

Step 3 - Select the Database or the table you wish to export

 

dpimpextP07.png

 

Step 4 - Click on the Export option up the top

 

dpimpextP08.png

 

Step 5  - Click Go

 

dpimpextP09.png

 

NOTE: You can use the Custom option to change a whole host of settings relating to how the database will be output. However, for 99% of cases, this won't be required. You can also use the Format: option if you want the file to be output as a LaTeX, CSV, PDF or anything else other than the standard SQL format. Again, for most cases, this won't ever be required.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk