Skip to Main Content

How to backup a WordPress database

Divi: the easiest WordPress theme to use

Divi: The best WordPress theme of all time!

With over 901.000 downloads, Divi is the most popular WordPress theme in the world. It is complete, easy to use and comes with more than 62 free templates. [Recommended]

Do you want to know how to manually make a WordPress database backup without using any plugin? Knowing this manual method allows you to quickly create a backup of your database whenever you need it.

In this tutorial, we will show you how to create a WordPress database backup manually.

backup of WordPress database

When and Why make a manual backup of the WordPress database

Always install and configure a WordPress backup for your site. This allows you to restore your site in case of problems.

Many users lose access to their WordPress dashboards due to a plugin hack or error. In these cases, most of our tutorials recommend to always make a full backup of WordPress, which will save you a lot of inconvenience.

However, since you cannot access the dashboard, it will be difficult for you to use a plugin for backups. A good knowledge of how to back up the WordPress database comes in handy.

A manual database backup is exactly similar to database backups created by a plugin. Having said that, let's take a look at this easy method that will allow you to back up your blog.

Easily create your website with Elementor

Elementor allows you to easily create any website design with a professional look. Stop paying expensive for what you can do yourself. [Free]

Backup of the database on phpMyAdmin

For this method, we will be using PhpMyAdmin. It is open source software that allows you to manage your MySQL database using a web interface. It is offered by default on almost all web hosts.

You must first log into your CPanel. After login, click phpMyAdmin in the database section.

PHPMYadmin database section

By clicking on it, a new window will open. Make sure to select your WordPress database from the phpMyAdmin interface. You will probably have to click on the name of your WordPress database to select it. You will be able to see the list of tables in the database.

Once your database is selected, click the Export link on the top horizontal menu.

Export phpMyAdmin menu

You will be asked to choose the export method. You must select " custom", Which will offer you more options:

export select tables from the wordpress database

Clicking on " custom“, You will have more options. All the tables in the database will be selected. From this interface you can choose the tables you want to include in the export.

Sometimes some WordPress plugins add their own tables to your database. If there are any tables that you want to exclude from the export, then you can deselect them. If you are not sure then it is best to leave them all selected. You can, in the compression option export the database in a compressed file.

Scroll to the bottom of the page, all you need to do is click " perform" page (in French).

execute export database phpmyadmin

PhpMyAdmin will now send you the export of your database as a zip or gzip file.

That's it, you have successfully taken a backup of the WordPress database manually. I have to remind you that it is preferable to install an automatic system which will do this for you. I therefore recommend " BackupBuddy" page (in French).

This article features 0 comments

Leave a comment

Your email address will not be published. Required fields are marked with *

This site uses Akismet to reduce unwanted. Learn more about how your comments data is used.

Back To Top