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.

Useful Info

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:

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)

***

"I am beyond impressed with what you have put together. I can tell that you put a ton of hard work into building what you have. You have the absolute best content on WordPress I have ever seen!" - Robert T. Jillie

***

Recommended Video Courses For WordPress Users

How To Optimize WordPressHow To Optimize WordPress

Learn how to optimize your WordPress site and improve your page loading speed.

More info: How To Optimize WordPress

Recommended Video Courses For WordPress Users

How To Use Amazon S3How To Use Amazon S3

Learn how to set up and use Amazon S3 to upload, store, manage, and protect your site’s images, large media files, downloadable files, stream videos and more.

More info: How To Use Amazon S3

Recommended Video Courses For WordPress Users

WordPress SecurityWordPress Security

Learn how to keep your WordPress site or blog secure and protected from malware, hackers and brute-force attacks.

More info: WordPress Security

Recommended Video Courses For WordPress Users

How To Use cPanelHow To Use cPanel

cPanel is a powerful and simple-to-use web hosting management software application that gives website owners the ability to quickly and easily manage their servers and websites using a simple and intuitive dashboard.

This video course will teach you how to use the main features of cPanel to manage your web hosting.

More info: How To Use cPanel

Recommended Video Courses For WordPress Users

How To Back Up & Restore WordPress SitesHow To Back Up & Restore WordPress Sites

Learn how to safely and automatically backup your WordPress files and database and how to easily restore your WordPress site if something were to happen.

More info: How To Back Up & Restore WordPress Sites

Recommended Video Courses For WordPress Users

How To Use FTPHow To Use FTP

This video course shows you how to use FTP (File Transfer Protocol) to transfer and upload files between your hard drive and your server using a free FTP program called Filezilla.

More info: How To Use FTP

Recommended Video Courses For WordPress Users

Using Password ManagersUsing Password Managers

Password Managers provide an easy and secure way to keep track of all your passwords. This video course shows you how to use two FREE powerful password management tools.

More info: Using Password Managers

Recommended Video Courses For WordPress Users

How To Install, Set Up & Use WordPress MultisiteHow To Install, Set Up & Use WordPress Multisite

Learn how to quickly and securely set up an online community of websites or blogs using the powerful WordPress Multisite feature.

More info: WordPress Multisite

Recommended Video Courses For WordPress Users

Google ToolsGoogle Tools

This video course will help you learn the basics of using Google Tools like Google Analytics and Gmail.

More info: Google Tools

Author: Martin Aranovitch

Martin Aranovitch is the founder of WPCompendium.org and the author of The Small Business Digital Manager. WPCompendium.org provides hundreds of FREE tutorials that show you how to use WordPress to grow your business online with no coding skills required! Get our FREE "101+ WordPress Tips, Tricks & Hacks For Non-Techies" e-course with loads of useful WordPress tips!

Originally published as How To Back Up Your WordPress Database Using phpMyAdmin.