Database - Create, Import or Export a Database in cPanel


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


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

  • Comments

Add Comment

Replying to