How to Create a WordPress Database Backup Manually

How to create a WordPress Database Backup manually – Do you want to know how to manually create a WordPress database backup without using any plugins? Knowing how to manual will make it easy to backup anytime when you need it. In this article, we will explain how to manually create a WordPress database backup.

How to Create a WordPress Database Backup Manually
How to Create a WordPress Database Backup Manually

When and why you should do a WordPress Database Backup

You should always install and set up backups for your WordPress automatically. It is very necessary that you can recover or restore your WordPress at any time when unwanted things happen. If you use the Niagahoster hosting service then you don’t have to worry because Niagahoster gives you a backup every week and you can restore it anytime through your cPanel if you use a business hosting plan.

Many WordPress users lost their admin access to their WordPress area after their WordPress was hacked or an error or error occurred on their WordPress (read: How to clean WordPress from Malware and viruses). In this case, a lot of tutorials suggest that you do a complete backup of WordPress or the whole.

However, because you can not log in into the admin area of your WordPress it will be very difficult for you to do a backup with the plugin. For that, you should be able to perform backups manually.

The results of manually created backups will have the same contents or content as the plugin created.

Creating a WordPress Database Backup manually through phpMyAdmin

For this step, we will use the backup with the help of phpMyAdmin. This phpMyAdmin feature is generally present and has been installed automatically on all web hosting services such as cPanel on best Hosting Indonesia, Niagahoster.

All you need to do is log in to your web hosting cPanel and then select the phpMyAdmin menu on the database section. WordPress from Malware and viruses). In this case, a lot of tutorials suggest that you do a complete backup of WordPress or the whole.

However, because you can not log in into the admin area of your WordPress it will be very difficult for you to do a backup with the plugin. For that, you should be able to perform backups manually.

The results of manually created backups will have the same contents or content as the plugin created.

After that, the phpMyAdmin menu will appear. Make sure you select the correct database according to your WordPress installation (tip: Check the wp-config. php file to see which database is used on your WordPress).

Once you have selected your database, then please select the Export menu.

How to Create a WordPress Database Backup Manually
How to Create a WordPress Database Backup Manually

Next, you will be asked to select the Export method. Please select the “Custom” menu to see Option. Make sure you select all the tables of your WordPress database to make sure your WordPress database table is backed up overall.

How to Create a WordPress Database Backup Manually
How to Create a WordPress Database Backup Manually

Scroll down your mouse cursor to see the option of the export output. By default, phpMyadmin will select the backup output of your database as a text. You can select these options in the ‘ Save output to a file > > compression ‘ menu. To output with compression, you can select the type zipped or gzipped.

Next, please scroll down and then select the Go button to continue the process. phpMyadmin will create a backup with your chosen format and you can save it directly to your PC.
Done, you have made a backup of your WordPress database manually.

Tags: