Do you want to know how to create WordPress database backup manually without using any plugin? After knowing the manual method, it will allow you to make WordPress database backup whenever you need it. In this post, we will show you how to create WordPress database backup manually.
Continue Reading: https://codex.wordpress.org/Backing_Up_Your_Database
When and Why Create WordPress Database Backup Manually
You should always setup a WordPress backup system for your website. This allows you retrieve your domain if something go wrong. Many users may lose their access on the WordPress admin area after a hack attempt or few plugin error. In these situations, most tutorials recommend you to create a complete WordPress backup. Since, you can not access the admin area, it would be very hard for you to use a plugin for backups. This is were knowing how to create WordPress database backup manually comes in handy. Manual database backup creation is same as the database backup created by the plugin. Lets take a look at how to easily make the WordPress database backup manually without using plugin.
For More Info: https://css-tricks.com/back-wordpress-database
1. Backing up WordPress Database Manually By Using phpMyAdmin
For this kind of method, we will be using phpMyAdmin which is an open source program that allows you to manage your MySQL database by using a web-based interface. It comes pre-installed on the most WordPress hosting providers.
First of all, you need to login to your WordPress hosting control panel. After login, click on the phpMyAdmin under the database section.
This will launch the phpMyAdmin window. Make sure that your WordPress database is selected inside the phpMyAdmin. If it is not, then click on your WordPress database name in order to select it. Also, you will be able to see the list of WordPress database table when it get selected. And once your database is selected, tap on the “Export link” from the top menu bar.
Then after, you will be asked to select the export method and you need to select the custom as it will give you more options to explore.
Clicking on the custom will reveal the more options. Firstly, it will display all your tables in your WordPress database as selected. Sometimes, WordPress plugins add their own tables to your database. If there are any tables that you would like to exclude from the export, then you can deselect them. If you are unsure, then it would be better in order to keep them all selected.
Now, scroll down to the output section. By default, phpMyAdmin will display you the output of the export processes as a text. Thus, you need to change that by selecting “Save output to a file” option. For compression, you need to select the zipped or gzipped option. Thereafter, you need to scroll down to the button of the page and tap on the “Go” button. phpMyAdmin will send you the database export as a gzip or zip file. That’s all, you have successfully made the manual WordPress database backup.
2. Create WordPress Database Backup Manually From cPanel
Most of the good WordPress hosting companies also offers easier way to download on demand backups. Here is how you can use that to create WordPress database backup manually.
Simply just login to your hosting control panel and scroll down to the files section where you will see the Backup button. HostGator, SiteGround and the Bluehost all have similar options.
On the backup page, scroll down to the partial backups section and click on your database name in order to download your database backup file.
Must Read: You can create WordPress database backup manually but keep it in mind that it is not an alternative solution to a proper backup for your WordPress website. There are few circumstances when you may not have access to your WordPress database at all. For instance, if your hosting company suspends your account or loses your data. Another possible reason is when some hackers has injected data into your WordPress database, then cleaning an infected or hacked database would be little difficult.
However, use a proper backup plugin in order to automatically store WordPress database backup on the cloud. You can use BackupBuddy that will automatically created and stores your backups on a cloud storage service such as DropBox, Google Drive or Stash. For other related information, see our guide on how to protect your WordPress site from virus attack and keep your domain safe from any kind of malware or virus attack.
That’s all, we hope that this post helped you to learn how to create WordPress database backup manually. You may also want to see our guide on how to detect a backdoor in hacked WordPress website and fix it quickly. Thank you.