Do you want to know how to make a plugin? Knowing the manual method allows you to quickly create a database backup whenever you need it. In this article, we will show you how to make a database backup manually. database backup manually without using a
Why should I know how to create a Database Backup manually?
You should always install and set up a backup system for your site. This allows you to restore your site should something go wrong. Many users lose access to their admin area after a hack attempt or some plugin error. In these cases, most tutorials recommend that you create a complete backup. However, since you cannot access the admin area, it would be hard for you to use a plugin for . This is where knowing how to make a database backup manually comes in handy. A manual database backup is exactly the same as the database backups created by a plugin.
Having said that, let’s take a look at how to easily make adatabase backup manually.
Backing Up WordPress Database Manually Using phpMyAdmin
For this method, we will be using PhpMyAdmin. It is an open source software that allows you to manage your MySQL database using a web-based interface. It comes pre-installed on most hosting providers.
First, you need to login to your hosting control panel. Upon login, click on phpMyAdmin under the database section.
This will launch phpMyAdmin window. Make sure yourdatabase is selected inside phpMyAdmin. If it isn’t, then click on your database name to select it. You will be able to see the list of database tables when it is selected.
Once your link from the top menu bar.is selected, click on Export
You will be asked to select the export method. You need to select custom as it will give you more options to explore.
Clicking on custom will reveal more options. First, it will show all your tables in yourdatabase as selected.
Sometimesplugins add their own tables to your . If there are any tables that you would like to exclude from export, then you can deselect them. If you are unsure, then it is better to keep them all selected.
Scroll down to the output section. By default, phpMyAdmin will show you the output of the export process as text. You need to change that by selecting ‘Save output to a file’ option. For compression, you need to select zipped or gzipped option.
Now you need to scroll down to the bottom of the page and click on the ‘Go’ button.
PhpMyAdmin will now send you the database export as zip or gzip file.
That’s all, you have successfully made a manuallydatabase backup.
Creating a Manual WordPress Database Backup from cPanel
Most good hosting companies also offer easier ways to download on demand backups. Here is how you can use that to make a manual database backup. Simply log in to your hosting control panel and scroll down to the files section where you will see the button. On the backups page, scroll down to partial backups section and click on your database name to download your database backup file.
You can also download yourfiles backup from this page if you need to.
There are situations when you may not have access to your hosting company suspends your account, or loses your data. Another possible scenario is when some hacker has injected data into your database, cleaning an infected would be a lot more difficult. Use a proper backup plugin to automatically store your database backups on the cloud. We recommend using BackupBuddy, it automatically creates and stores your on a service like Drive, DropBox, or Stash.database at all. Like if your
That’s all, we hope this article helped you learn how to make a database backup manually!