How to Manually Backup Your WordPress Database

>How to Manually Backup Your WordPress Database
  • backup database

Yes, a lot of plugins can do that, but if you just want to be extra safe, like us, you might want to manually backup your WordPress database as well.

We always do that, even if our must-have plugin, Updraft Plus (this is an affiliate link), does it already.

You can never be too safe when it comes to WordPress! We learned that the hard way!

In this article, we’ll show you two methods through which you can perform a manual backup: using phpMyAdmin or cPanel’s backup system.

How to backup WordPress database using cPanel

This is the more simple method.

1. Log in to your cPanel and click on Backups or Create Backup, or whatever it’s named in your cPanel. It depends on the hosting company.

siteground cpanel backup manager

2. Click on the WordPress database found under Download a MySQL Database Backup:

manually backup wordpress database from cpanel

Your database will have another name, of course.

3. Save it wherever you want.

It’s best not to keep your WordPress backups only on your computer. Use something like Dropbox, Google Drive, etc.

How to backup WordPress database using phpMyAdmin

This method is a bit more complicated.

1. Log in to cPanel and click on phpMyAdmin:

siteground cpanel phpmyadmin

2. Select your WordPress database:

phpmyadmin wordpress database

3. After you’ve selected it, all the tables inside your database will show up, but just ignore them. You need to click on the Export tab now:

export wordpress database phpmyadmin

4. After you click on Export, you’ll see this:

export phpmyadmin database

5. The Quick Method and SQL Format should be selected by default, so leave them like that. Just click Go and then OK on the pop-up in order to save the SQL file.

save wordpress mysql database

That’s it! You’re done!

The reason why you shouldn’t choose the Custom method instead of the Quick one is that it gets too advanced, and if you don’t know exactly what you’re doing, you might damage things.

Conclusion

You should make backups on a regular basis, especially after you add a new page or post, or make modifications to your site. And the database should always be backed up along with all your files, either through a plugin or manually.

Hope you found this post useful! If you have any questions or just want to share something with us, please drop a comment!

WP Rocket - WordPress Caching Plugin
By |2018-10-28T00:35:07+00:00June 21st, 2015|Tips, WordPress|0 Comments

Leave A Comment

SUBSCRIBE BEFORE YOU GO?

- Get guides and offers right into your inbox -

The type of emails that you would like to receive (multiple selection allowed):

You can unsubscribe at any time by clicking the link in the footer of the emails. For more information, please check the privacy policy.

I use MailChimp as my emailing service. By subscribing, you understand that your email and preferences will be transferred to MailChimp. Learn more about MailChimp's privacy practices here.

close-link