Backup Your WordPress Site via cPanel
How to Backup Your WordPress Files Manually
This is so easy you can do it in the time it takes to brew a mug of coffee. Here’s the procedure:
- Login to your web host and navigate to cPanel. For most web hosts, the cPanel is usually the first page you encounter when you login
- Navigate to the File Manager, which should lead you to your public_html or Home directory
- From here, just locate your WordPress directory. This is the folder you want to backup
- Unfortunately, you can’t download the WordPress folder in File Manager without first compressing it. Worry not though, compressing a folder needn’t be challenging
- Click on your WordPress directory, and select Compress from the menu bar. Alternatively, right-click on the folder and choose Compress from the drop-down options menu that appears
- Choose the compression type e.g. ZIP, from the dialog box that opens. I always go with a ZIP archive
- Then just hit the Compress File(s) button and wait for the process to run its course. Your server will save your compressed WordPress folder
- Click on the archive you just created and choose Download from the menu. Alternatively, right-click on the archive and choose Download.
- Choose a secure location on your hard disk and save your backup
- And that’s it!
Tip: Upload the backup to your Dropbox account, Google Drive, burn it to a DVD/CD, email it etc – just make sure you have several copies to ensure you don’t lose your site should one of the backup dies.
How to Backup Your WordPress Database Manually
Now that we have a fresh copy of your WordPress files, let’s backup your WordPress database, so we can have a full backup that will come in handy on that proverbial rainy day. This is also so easy you will be backing up your site whenever without breaking a sweat.
Just navigate to your cPanel and locate phpMyAdmin. It’s usually located under Database Tools:
Log in, which should lead you to the phpMyAdmin administration panel:
Hit the Databases tab to list your databases. If you installed your WordPress site using third-party platforms such as Softaculous or Mojo Marketplace, you might have no idea which database to work with. Same case applies if you have several databases with funny names like mine in the image above. What to do?
From your File Manager, navigate to your WordPress directory and locate the wp-config.php file. Right-click on wp-config.php and choose view:
In the window that opens, you want to locate this line:
Your database name is the value contained in the second set of single quotation marks, which is ‘database_name’ in our example above. Armed with this info, locate your database in phpMyAdmin. Click on the database to open it. You should see something such as:
Select all the tables you’d like to backup by ticking the checkboxes. Click “Check All” at the bottom to select all at once. Once you’ve selected the tables, hit the Export tab. Select the export method, and set format to SQL:
Hit the Go button, and save your database in a secure folder on your PC. Remember to save copies in the same locations you saved copies of your WordPress files. And that’s it, you now have a full backup of your WordPress site.