How To Make a  Database Backup Manually for WordPress?

How To Make a Database Backup Manually for WordPress?

Do you want to understand the way to make a WordPress database backup manually without employing a plugin? Knowing the manual method allows you to quickly create a database backup whenever you would like it. during this article, we’ll show you ways to form a WordPress database backup manually.

When and Why Make a WordPress Database Backup Manually

You should always install and set up a WordPress backup system for your site. this enables you to revive your site should something fail.

Many users lose access to their WordPress admin area after a hack attempt or some plugin error. In these cases, most tutorials recommend that you simply create an entire WordPress backup.

However, since you can’t access the admin area, it might be hard for you to use a plugin for backups. this is often where knowing the way to make a WordPress database backup manually comes in handy.

A manual database backup is strictly equivalent because the database backups are created by a plugin.

Having said that, let’s take a glance at the way to easily make a WordPress database backup manually.

Backing Up WordPress Database Manually Using phpMyAdmin

For this method, we’ll be using PhpMyAdmin. it’s open-source software that permits you to manage your MySQL database employing a web-based interface. It comes pre-installed on most WordPress hosting providers.

First, you would like to log in to your WordPress hosting instrument panel. Upon login, click on phpMyAdmin under the database section.

This will launch the phpMyAdmin window. confirm your WordPress database is chosen inside phpMyAdmin. If it isn’t, then click on your WordPress database name to pick it. you’ll be ready to see the list of WordPress database tables when it’s selected.

Once your database is chosen, click on the Export link from the highest menu bar.

You will be asked to pick the export method. you would like to pick custom because it will offer you more options to explore.

Clicking on custom will reveal more options. First, it will show 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 export, then you can deselect them. If you are unsure, then it is better to keep them all selected.

Scroll right down to the output section. By default, phpMyAdmin will show you the output of the export process as text. you would like to vary that by selecting the ‘Save output to a file’ option. For compression, you would like to pick the zipped or gzipped option.

Now you would like to scroll right down to the rock bottom of the page and click on on the ‘Go’ button.

PhpMyAdmin will now send you the database export as zipping or gzip file.

That’s all, you’ve got successfully made a manual WordPress database backup.

Creating a Manual WordPress Database Backup from cPanel

Most good WordPress hosting companies also offer easier ways to download on-demand backups. Here is how you’ll use that to form a manual WordPress database backup.

Simply log in to your hosting instrument panel and scroll right down to the files section where you’ll see the Backup button. Bluehost, SiteGround, and HostGator all have similar options.

On the backups page, scroll right down to the partial backups section and click on on your database name to download your database computer file.

You can also download your WordPress files backup from this page if you would like to.

Editor’s Note: you’ll make WordPress database backups manually, but confine in mind that it’s not an alternative to a correct backup solution for your WordPress site.

There are situations once you might not have access to your WordPress database in the least. Like if your hosting company suspends your account, or loses your data.

Another possible scenario is when some hacker has injected data into your WordPress database, cleaning an infected database would be tons harder.

Use the correct backup plugin to automatically store your WordPress database backups on the cloud. We recommend using BackupBuddy, it automatically creates and stores your backups on a cloud storage service like Google Drive, DropBox, or Stash.

See our guide on the way to keep your WordPress content safe with BackupBuddy for detailed instructions.

That’s all, we hope this text helped you find out how to form a WordPress database backup manually. you’ll also want to ascertain our guide on the way to restore your WordPress site with just a database backup.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

Devid James
Written by

Devid James

Devid James is a versatile content writer who enjoys working on a variety of subjects. He is really interested in experimenting with new marketing methods and buyer personas.

Table of Content

Table of Contents