PhpMyAdmin Backup Database: How to Backup & Restore It in a Few Simple Steps

Here’s how you can backup and restore through PhpMyAdmin without any complications

Ask any website administrator about their worst nightmare (as far as work is concerned), and all of them would say that it’s losing their whole database. And the irony is that every website admin has experienced it at least once in their professional life. This could’ve happened due to a cyber-attack, while doing local development or while migrating hosts. Whichever way it happened, the thought of it is terrifying to say the least. And that’s why automatic backup has become a regular practice in many organizations. In this post, we’re going to outline the simple steps to backup and/or restore your MySQL Database using phpMyAdmin.

Let’s get started!

How to Backup MySQL Database Using phpMyAdmin

1. First, log into your cPanel account.
2. Then, on the Home screen, scroll down the page to Databases and click on phpMyAdmin.
3. Now, from the left navigation tree, select the database(s) that you want to backup.
4. Click on the Export tab.
5. Select the Quick export method and click on Go.
6. Once done, your database will be downloaded to your local machine’s default downloads location.

Voila! You just backed up your MySQL database using phpMyAdmin.

Restore your MySQL database from a phpMyAdmin Backup

1. Log into your cPanel account.
2. Now, from the left navigation tree, select the database(s) that you want to backup.
3. Click the Check All option.
4. From the drop-down menu, click on Drop.
5. Click Yes to give confirmation.
6. Now, click on the Import tab.
7. Click on the Choose File button to locate the MySQL backup file. 
8. Click Go.

Congratulations! You have just performed restoration of your phpMyAdmin backup database.

Give Away Your Backup Management Stress to CodeGuard

CodeGuard by Sectigo (formerly ‘Comodo’) is a flexible, reliable backup platform that backups up your entire website, including the files and the databases. With CodeGuard, you can not only take backups, but you can automate incremental backups and secure the backed-up databases through encryption. All of this at cost less than a Starbucks coffee. We’d call that a pretty great investment!