How To Make a WordPress Database Backup Manually

  • January 15, 2023
  • elkenz
  • 5 min read

Do you wish to know make a WordPress database backup manually with out utilizing a plugin? Figuring out the guide methodology permits you to rapidly create a database backup everytime you want it. On this article, we’ll present you make a WordPress database backup manually.

WordPress Database Backup Manually

When and Why Make a WordPress Database Backup Manually

It is best to at all times set up and setup a WordPress backup system in your website. This lets you restore your website ought to one thing go unsuitable.

Many customers lose entry to their WordPress admin space after a hack try or some plugin error. In these instances, most tutorials advocate that you simply create a whole WordPress backup.

Nevertheless, since you can not entry the admin space, it could be arduous so that you can use a plugin for backups. That is the place figuring out make a WordPress database backup manually is useful.

A guide database backup is strictly the identical because the database backups created by a plugin.

Having mentioned that, let’s check out simply make a WordPress database backup manually.

Backing Up WordPress Database Manually Utilizing phpMyAdmin

For this methodology we might be utilizing PhpMyAdmin. It’s an open supply software program that permits you to handle your MySQL database utilizing an internet based mostly interface. It comes pre-installed on most WordPress internet hosting suppliers.

First it’s good to login to your WordPress internet hosting management panel. Upon login, click on on phpMyAdmin beneath the database part.


This may launch phpMyAdmin window. Be certain your WordPress database is chosen inside phpMyAdmin. If it isn’t, then click on in your WordPress database identify to pick out it. It is possible for you to to see the listing of WordPress database tables when it’s chosen.

As soon as your database is chosen, click on on Export hyperlink from the highest menu bar.

phpMyAdmin Export Button

You can be requested to pick out the export methodology. It’s essential choose customized because it provides you with extra choices to discover.

phpMyAdmin Export Method

Clicking on customized will reveal extra choices. First it would present all of your tables in your WordPress database as chosen.

Generally WordPress plugins add their very own tables to your database. If there are any tables that you simply wish to exclude from export, then you may deselect them. If you’re not sure, then it’s higher to maintain all of them chosen.

phpMyAdmin Custom Export

Scroll right down to the output part. By default, phpMyAdmin will present you the output of the export course of as textual content. It’s essential change that by choosing ‘Save output to a file’ choice. For compression it’s good to choose zipped or gzipped choice.

Now it’s good to scroll right down to the underside of the web page and click on on the ‘Go’ button.

PhpMyAdmin will now ship you the database export as zip or gzip file.

That’s all, you’ve gotten efficiently made a manually WordPress database backup.

Making a Handbook WordPress Database Backup from cPanel

Most good WordPress internet hosting firms additionally supply simpler methods to obtain on demand backups. Right here is how you should use that to make a guide WordPress database backup.

Merely login to your internet hosting management panel and scroll right down to the information part the place you will note the Backup button. Bluehost, SiteGround, and HostGator all have related choices.

On the backups web page, scroll right down to partial backups part and click on in your database identify to obtain your database backup file.

Download a WordPress database backup using cPanel

It’s also possible to obtain your WordPress information backup from this web page if it’s good to.

Editor’s Observe: You may make WordPress database backups manually, however needless to say it isn’t an alternative choice to a correct backup answer in your WordPress website.

There are conditions when chances are you’ll not have entry to your WordPress database in any respect. Like in case your internet hosting firm suspends your account, or loses your knowledge.

One other doable state of affairs is when some hacker has injected knowledge in your WordPress database, cleansing an contaminated database can be much more tough.

Use a correct backup plugin to mechanically retailer your WordPress database backups on the cloud. We advocate utilizing BackupBuddy, it mechanically creates and shops your backups on a cloud storage service like Google Drive, DropBox, or Stash.

See our information on preserve your WordPress content material secure with BackupBuddy for detailed directions.

That’s all, we hope this text helped you discover ways to make a WordPress database backup manually. You might also wish to see our information on restore your WordPress website with only a database backup.

If you happen to appreciated this text, then please subscribe to our YouTube Channel for WordPress video tutorials. It’s also possible to discover us on Twitter and Fb.