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




Step 3 - Select the correct database from the left panel




Step 4 - Click the Import button




Step 5 - Select the database you wish to upload




6 - Click Go!






How to Export a Database using PHPMyAdmin

Step 1 - Log in to cPanel


Step 2 - Click on the PHPMyAdmin icon




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




Step 4 - Click on the Export option up the top




Step 5  - Click Go




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


Powered by Zendesk