How To Back Up Your WordPress Database Using phpMyAdmin

Learn how to backup your WordPress database using phpMyAdmin.

How To Back Up Your WordPress Database Using phpMyAdminThis tutorial is part of our WordPress Management tutorial series. In this tutorial, we show you how to backup your WordPress database using phpMyAdmin.

***

How To Back Up Your WordPress Database Using phpMyAdmin

What Is phpMyAdmin?

phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions.

(source: Wikipedia)

phpMyAdmin Backup Method – Step By Step Tutorial

To perform a MySQL database backup of your WordPress site using phpMyAdmin, do the following:

Log into your cPanel administration area …

How To Back Up Your WordPress Database Using phpMyAdmin

Click on phpMyAdmin in the ‘Databases’ section of your administration panel …

How To Back Up Your WordPress Database Using phpMyAdmin

This takes you to the main ‘phpMyAdmin’ section …

How To Back Up Your WordPress Database Using phpMyAdmin

Click on the MySQL database associated with your WordPress site …

How To Back Up Your WordPress Database Using phpMyAdmin

Most default WordPress installations automatically assign the suffix “wrdp1” to the database. In the example above, the database name is “shosetri“.

This loads the MySQL data tables structure into the main window of your phpMyAdmin panel …

How To Back Up Your WordPress Database Using phpMyAdmin

Optimize MySQL Database Tables

The first part of the maintenance process is to optimize your tables if there is anything showing in the ‘Overhead’ column …

How To Back Up Your WordPress Database Using phpMyAdmin

To begin optimizing your database tables, click on the Check All link at the bottom of the tables list to select all tables …

How To Back Up Your WordPress Database Using phpMyAdmin

Choose ‘Analyze table’ from the drop down menu next to the link you have just clicked …

How To Back Up Your WordPress Database Using phpMyAdmin

The ‘Analyze table’ query helps to speed up the optimization process.

The query will automatically be executed …

How To Back Up Your WordPress Database Using phpMyAdmin

Next, click the Check All link again to select all tables and select ‘Optimize table’ from the drop-down menu …

How To Back Up Your WordPress Database Using phpMyAdmin

Once the query has been executed, the ‘Overhead’ column should be cleared …

How To Back Up Your WordPress Database Using phpMyAdmin

Export MySQL Database Tables

After optimizing your tables, the next step is to export (backup) your MySQL data to your local hard drive.

To begin the export process, click on Export in the phpMyAdmin menu …

How To Back Up Your WordPress Database Using phpMyAdmin

Leave all the settings as shown below and click on Go

How To Back Up Your WordPress Database Using phpMyAdmin

Select ‘Save File’ and click OK

How To Back Up Your WordPress Database Using phpMyAdmin

Select a folder on your hard drive to save your SQL file containing all of your MySQL data and click on Save

How To Back Up Your WordPress Database Using phpMyAdmin

Your file will begin downloading. Depending on the size of your database, this could take a couple of minutes …

How To Back Up Your WordPress Database Using phpMyAdmin

Using phpMyAdmin to export a large database can result in errors and an incomplete export of your data. If you experience errors as a result of trying to export a very large database, please contact your webhosting provider for assistance.

Check & Repair MySQL Database Tables

It’s a good idea while you’re performing your MySQL maintenance to run an automatic check of your database tables, just to make sure everything is ok.

Using the ‘Check Table’ and ‘Repair Table’ functions can help you perform simple repairs to your MySQL database.

Important

We recommend running the ‘Check table’ and ‘Repair table’ functions only after performing a backup of your MySQL database (“Export table” query). This will allow you to restore your original data and help you reverse any errors that may occur if the repair process is unsuccessful.

To check your tables, click the ‘Check All’ link to select all tables and choose ‘Check table’ from the drop-down menu …

How To Back Up Your WordPress Database Using phpMyAdmin

The results are displayed on the screen after the ‘Check table’ query has been executed. In the example below, errors were detected that require using the ‘Repair table’ query …

How To Back Up Your WordPress Database Using phpMyAdmin

To perform simple repairs, click the ‘Check All’ link to select all tables, then select the ‘Repair table’ option from the drop-down menu …

How To Back Up Your WordPress Database Using phpMyAdmin

The ‘Repair table’ query will automatically execute and the results will be displayed when the process has completed …

How To Back Up Your WordPress Database Using phpMyAdmin

warning

Extensive damage to your MySQL data tables may require performing difficult repairs which are beyond the scope of these training modules. If this happens, consult your hosting provider for advice. You may be required to reinstall or restore your database, or use an experienced and professional technical services provider to repair the problem.

DO NOT select the ‘Drop’ or ‘Empty’ option from the query drop-down menu unless you absolutely know what you are doing. Doing so will clear or entirely delete your database tables.

When you have finished performing the MySQL database maintenance process for your WordPress site, close the ‘phpMyAdmin’ tab to exit …

How To Back Up Your WordPress Database Using phpMyAdmin

Automating MySQL Backups

In other tutorials in this training module, we will explore tools that can help automate some of your WordPress site maintenance processes. These options include using FREE WordPress plugins that do some of the required maintenance tasks and plugins that integrate and automate essential maintenance processes.

How To Back Up Your WordPress Database Using phpMyAdmin

Additional Tutorials

To learn how to perform a WordPress database backup using cPanel’s Backup Wizard, see the tutorial below:

Practical Tip

To learn how to automate your WordPress backups using WordPress plugins, go here:

Next

Now that you know how to perform regular MySQL database maintenance for your WordPress site, the next step is to learn how to back up your WordPress site files.

To learn how to backup your WordPress site files, see the tutorial below:

How To Back Up Your WordPress Database Using phpMyAdmin

(Source: Pixabay)

***

"This is AMAZING! I had learnt about how to use WordPress previously, but this covers absolutely everything and more!! Incredible value! Thank you!" - Monique, Warrior Forum

***