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 backup of the database data of WordPress manually.
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. That said, let's take a look at this simple method that will allow you to save 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.
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.
You will be asked to choose the export method. You must select " custom", Which will offer you more options:
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"
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"
