Stop wasting time and money!

Easily create your WordPress website or blog today.

Elementor is the easiest and most importantly, the fastest tool to create any type of WordPress website or blog. No technical knowledge is required and is perfect for beginners or professional users. You can do it yourself so do it!

Do you want to know how to manually make a database backup? data of WordPress without using a plugin? Knowing this manual method allows you to quickly create a backup of your database. data 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.

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 tables you want to exclude from the export, then you can deselect them. If you're not sure, then it's best to leave them all selected. You can, in the compression option, export the database to a compressed file.

Scroll to the bottom of the page, all you need to do is click " Execute" 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).

%d bloggers like this page: