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.