Do you want to manually create WordPress database backups without using the plugin?
Like backing up important files on a computer, it is necessary to have a full backup of your WordPress site. When an unexpected situation occurs, due to the update the database becomes corrupted, the backup data can be immediately restored.
WordPress site backup is a popular business field where developers compete heavily through different types of plugins. As a rule of thumb, when you have other options, it is recommended to avoid plugins.
In this article, we will discuss in detail how we will manually backup the WordPress site without the plugin.
Why You Need to Backup?
If you have limited PHP knowledge and you are editing your WordPress core files or moving in your database, there are many more possibilities to break your website. In fact, you have already experienced the awesome white screen of silence or are not able to login to your WordPress admin. This is such a case where backups are easy to operate.
But this is not just a case of user error where backups may be required. There may be times when you usually log in to your administrator to update the plugin and the next thing you know is that your site is broken.
Or worse, your website gets hacked and you do not even know what to do.
These are all common problems that face WordPress users, and quite clearly, not just WordPress users, but also about any website.
If you want to backup WordPress data, please take a close below look.
Backing Up WordPress Database Manually Using phpMyAdmin
For this method, we will use “PhpMyAdmin”. This is open source software that allows you to manage your “MySQL” database using the web-based interface. It is pre-installed on most WordPress hosting providers.
The most important aspect of backing up the WordPress site is copying all the content on the site. WordPress MySQL databases store table text content as entries while media files such as images, videos, PDF etc. are stored in separate upload folders.
The process here will explain the database and back up using CPANEL hosting if the process is using different hosting accounts, then this process will be the same.
Log in to your CPanel Hosting account and see the phpMyAdmin icon under the “Database” and “Database Tools” section.
Click PhpMyAdmin and log in with your credentials (Typically this will be the CPL user ID/password and you will be automatically logged in phpMyAdmin).
You will see a list of the databases on the left panel, click on the database that you want to back up to expand the tables corresponding to the database.
Click on the “Export” tab and choose the following options. And you will be asked to select an export method. You need to choose Custom because it will give you more options to explore.
Clicking on custom will result in more options. First of all, it will show all your tables in your WordPress database because it has been selected.
Sometimes WordPress plugins add your tables to your database. If there is a table that you want to exclude from export, then you can opt out of them. If you are not sure, then it will be better to choose them.
Scroll to the output section. By default, phpMyAdmin will show you the output process of the export process as text. You must change this by selecting the ‘Save File to Output’ option. For compression, you need to choose zip or jeep option.
Now you need to scroll down the page and click on the ‘Go’ button.
PhpMyAdmin will now send you a zip export or export database as a zip file.
This is everything, you have made a backup of the WordPress database manually.
At the end of these articles, if you like this post, then share it further. If you have any questions, tell it in the comment box below.