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.

Cloudways

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!

Cloudways

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.

Cloudways

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.

Cloudways

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!