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



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



Step 3 - Create a user for the database. Again this will start with cpanelusername_

For the Password we recommend using the password generator which will

make a password that's hard to crack. Make sure you copy the password

and username somewhere safe on your computer.




Step 4 - Select the user's privileges and add the user to that database. If

this is the main user for this database you will want to give all

privileges.



Step 5 - All done!



How to Import a Database using PHPMyAdmin

Open the phpMyAdmin tool


Before you read this, ensure you have a 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 1 - Select the correct database from the left panel




Step 2 - Click the Import button




Step 3 - Select the database you wish to upload




Step 4 - Click Go



How to Export a Database using PHPMyAdmin


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




Step 2 - Click on the Export option up the top




Step 3 - 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 anthing else other than the standard SQL format. Again, for most cases this won't ever be required.


Related Articles