While there are several plugins that do a great job of simplifying the process of (automatically) backing up your WordPress site, images and settings (my favorite is BackupBuddy by ithemes)–there are a handful of times when a manual backup is required.

This is usually while troubleshooting other issues within WordPress such as when you temporarily cannot access your admin dashboard (or your backup plugin as a result), or when newly installed plugins do not play nicely with other plugins–or stop working altogether.

You should always create a full backup of your site before making changes to the site (to resolve an issue or customize your site) that may fail or otherwise provide unwanted results. When these kinds of problems arise, instead of building your entire site from scratch again, you can simply restore your site from the backup file.

The two most common ways to manually backup a WordPress site utilize free and easy-to-use tools on your server (provided by your web host)–phpMyAdmin and cPanel.

How to make a WordPress backup using phpMyAdmin


  1. Login to phpMyAdmin and select your WordPress database.
  2. Once you have selected your WordPress database, click the “Export” tab.
  3. If prompted, choose a compression method (gzip is best), and click “Execute.”
  4. If prompted by your browser, click “Yes” to download the database file.

How to make a WordPress backup using cPanel


  1. Login to cPanel.
  2. Click on “Backups.”
  3. Click on the database you want to download.
  4. Confirm any dialog boxes from your browser, if prompted.

That’s it! Of course it’s much easier to hire a WordPress developer to troubleshoot your issues and make optimal changes to your site and server–which would begin with a full site and database backup.

By |2018-11-01T17:20:45+00:00June 15th, 2015|Categories: Web Tips-n-Tricks|0 Comments

About the Author:

Leave A Comment

Website Content and Design

Website Content and Design

Copyright © eXcelisys, Inc., all rights reserved. No unauthorized use permitted; all derivative works must have prior approval. All content – including design and copy within the eXcelisys website is protected under international copyright laws. eXcelisys will prosecute ANYONE who borrows or steals any derivative or facsimile of the content and design of eXcelisys’ website without written approval or permission. Read More



FileMaker®, FileMaker Pro® and the referencing FileMaker® logos are trademarks of FileMaker, Inc., in the United States, the European Union and other countries. MySQL® and MySQL® Logos are registered trademarks of MySQL AB in the United States, the European Union and other countries. The PostgreSQL elephant logo “Slonik” is a registered trademark of the PostgreSQL Global Development Group. Read More

Privacy Policy

Privacy Policy

We will never give or sell your email address or contact information to anybody, for any reason. There are no eXceptions. We do not make our customer list available to anyone outside of eXcelisys at all, ever.

There is no way that submitting your information to eXcelisys will result in you receiving “spam” or other junk mail from eXcelisys if you have requested us not to do so. Read More