The cPanel backup interface allows you to generate and download a backup of your MySQL databases. Backing up your website’s database periodically is always recommended, as it can save you from a lot of pain in case anything happens with your data. It is often necessary to take a backup (or “dump”) of an entire database management system along with all databases and tables, including the system databases which hold the users, permissions, and passwords.

1) Log into cPanel.

2) Look for the “Files” section and click on the “Backup” icon.

3) In the “Partial Backup” section under “Download a MySQL Database Backup “ click on your database name you want to backup, in this case, it’s chemiclo_demo and the download will start automatically.

A copy of the database will now to saved on your PC, and you should now see the compressed .sql.gz file in the folder your web-browser downloaded it.

How to restore a MySQL Database Backup

If your database is corrupted or you have removed some useful data,  restoring the database from a previous working backup might be a great option to save the day. Luckily this can easily be done by following the next steps:

1) Log into cPanel.

2) Look for the “Files” section and click on the “Backup” icon.

3) In the “Partial Backup” section click the “Choose File” button located under “Restore a MySQL Database Backup “  and select the backup file you want to use from your PC and click “Open“.

4) Now the name of the backup file you selected should be displayed, please double check that this is the right backup and click “Upload“.

5) A new tab will open showing you information about the restore process.

1) Click the database you wish to export, in this example we’ll use the chemiclo_demo database.

2) Next, click on the “Export” tab and select the format in which you want to export the database.

3) Click on the “Go” button to start the export/backup process of the entire database.

4) You can also export only certain tables from your database, from the export tab go to the “Export Method” section click on the “Custom – display all possible options“. This will show you a list of all the tables created in the database.

5) Select the tables you want to export, leave the other options unchanged and click on the “Go” button to proceed.

1) First, we’ll need to select the database, in this example, we’ll use the chemiclo_demo database.

2) We’ll see here all the tables within this database listed, click on the “Drop” link next to the table you wish to delete (drop).

3) A confirmation pop-up message will appear, make sure you are deleting the right table and click “OK“. A message will appear indicating that your table has been dropped and the table is no longer listed in the database’s list of tables.

4) We can also delete (drop) specific fields from this table by clicking the delete icon. In this example, we selected the test3 table and dropped the junk field.

5) A confirmation pop-up message will appear, make sure you are deleting the right field and click “OK”.

PhpMyAdmin allows you to perform a wide range of operations with MySQL. In this tutorial, we’ll familiarize ourselves with databases and phpMyAdmin.

1) Log into cPanel

2) Look for the “DATABASES” section and click on “phpMyAdmin “, you’ll be redirected to the phpMyAdmin interface.

3) From this new screen, we have direct access to all the databases created under this cPanel account, they are all listed on the left side. In this example, we have the databases “chemiclo_demo” and “information_schema“. A database consists of one or more tables, the information is recorded in the tables.

4) You can also view all the databases created under this account if you click the “Databases” tab:

Let’s have look at the options available in the top menu from phpMyAdmin

• From the SQL tab, we can open an SQL Query window, here we can enter an entire SQL query code and execute it by pressing “Go“.
• In the Status tab, we’ll find information regarding the MySQL server since the last restart, like the MySQL uptime, number of active connections and traffic volume.
• We can export databases to our local computer if we click on the Export tab and hit “Go”.
• We can import databases from our local computer if we click on the Import tab and hit “Go”.
• In the Variables tab, you’ll see will see a list of the MySQL server system variables.
• In the Charsets tab, you’ll find all the charsets and collations supported by the MySQL server.
• In the Charsets tab, you’ll see a list with all the engines supported by the MySQL server

Let’s move back to the current databases installed on this cPanel account

If we click on the chemiclo_demo database all the tables created under this database will be listed. As we can see in this screen, this database has only 3 tables created.

From here we can see more information about the tables contained in the database, as well as perform several actions:

• Browse a table to see the individual records.
• See the Structure of a table and perform certain actions.
• Search through a table for specific keywords.
• Insert new rows (or fields) into a table.
• Empty or delete the contents of a table.
• Delete or drop an entire table altogether.

1) Log into cPanel.

2) Look for the “DATABASES” section and click on “MySQL® Databases”.

3) Look for the “Current Databases “ section, here you can either change the rename or delete a MySQL database. Click on any of these links and follow the on-screen instructions to complete your action.

1) Log into cPanel.

2) Look for the “DATABASES” section and click on “MySQL® Databases”.

3) Look for the “Current Users “ section, here you can either change the password, rename or delete a MySQL username. Click on any of these links and follow the on-screen instructions to complete your action.

1) Log into cPanel.

2) Look for the “DATABASES” section and click on “MySQL® Database Wizard “.

3) In the next window enter the name of your database and hit “Next Step”.

4) Here you’ll need to choose the username and enter the password you want to be associated with the user in both fields. You can also click the “Password Generator” and cPanel generates a random, strong password for your username.

5) On the next page, you’ll assign privileges for the user to the database. If you want to assign full privileges for the user just check the box next to “All Privileges” and then click Next Step.

6) You’ll see a confirmation message that the database and username have been created.