How to secure complete backup of your WordPress website?

We do maintain the backup of our shared hosting clients' accounts regularly, however it is highly recommended to secure a local copy, especially when you are going to make any change in your WordPress website like version upgrade. This article will guide you to secure the complete backup of your WordPress website. Let us go through each step one-by-one:

Steps to backup your MySQL database

Using phpMyAdmin

  1. Login to phpMyAdmin.

  2. Click on Databases in your phpMyAdmin panel. (It may not be necessary to do this, depending on your version of phpMyAdmin)

    phpMyAdmin - List of Databases

  3. You may have several databases. Click the one that holds your WordPress data, the database you created when you installed WordPress. (In older versions this may be done through a pull-down menu.)

  4. Below is a picture of the default tables in the Structure view tab. You may have more tables -- this would happen if you have any statistics plugins or anti-spam plugins.

    List of Tables under Selected Database

  5. Click Export. There are two methods to export, Quick and Custom:

    • If you choose Quick export, it allows you to download an .sql file to your computer right away after you click "Go".

    • If you choose Custom export, follow these steps:

      • Select all the tables.

        Select All or Desired Tables to Take the Backup

      • In the Output section check Save output to a file and select None for Compression. (If your database is very large use a compression method)

        Select Save Output to a File Option

      • Select SQL from the Format drop-down menu.

        Select SQL from Format Dropdown Option

      • Check "Add DROP TABLE": this can be useful for overwriting an existing database.

        Select Add Drop Table Option to Overwrite Existing Database

      • Check "IF NOT EXISTS": this prevents errors during restores if the tables are already there.

        Select If Not Exists Option to Prevent Errors During Restore

      • Click Go. The data will now be saved into your computer.

  6. Keep these files safe, copied and stored in separate places on separate media.

Using cPanel


Kindly visit the following article to take MySQL database backup via cPanel.

https://manage.accuwebhosting.com/knowledgebase/918/How-to-Take-MySQL-database-backup-from-cPanel.html

Using WebsitePanel


Kindly visit the following article to take MySQL database backup via WebsitePanel.



Steps to backup your Emails


To take the backup of your emails, you can configure your email accounts into any email client program (like Microsoft Outlook, Mozilla Thunderbird, etc.) and download all the emails into your local system. Please check the following URL to configure your email account with an email client software:

https://manage.accuwebhosting.com/knowledgebase/9/Email-Clients


Steps to backup the Web-contents


Using an FTP client software, you can download your web contents into your local system. For that, first you will need an FTP account. If you do not know how to create an FTP account then kindly visit the following URL:

Using cPanel

 
https://manage.accuwebhosting.com/knowledgebase/1988/How-to-create-additional-FTP-accounts-in-cPanel.html

Using WebsitePanel


https://manage.accuwebhosting.com/knowledgebase/284/How-to-in-Create-an-FTP-account-in-WebsitePanel.html

Once you have an FTP account, visit the following article to configure that FTP account with any FTP client software and download your web contents:

https://manage.accuwebhosting.com/knowledgebase/113/Complete-FTP-guide-with-all-FTP-clients


  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

How to Leverage Browser Caching of WordPress Website via .htaccess?

If you've ever checked your WordPress website in Performance Tools such as Google PageSpeed...

How to Enable Gzip Compression In WordPress via .htaccess file?

When Gzip compression isn't enabled on WordPress website, Google PageSpeed Insight gives you a...

How to fix Error establishing a database connection in WordPress?

An error establishing a database connection in WordPress is a worst nightmare for all WordPress...

How To Fix An Error "SSL certificate problem: unable to get local issuer certificate"

This error can be encountered while upgrading WordPress or installing a WordPress plugin from the...

How to Deactivate All Plugins Without Accessing WP-Admin?

While troubleshooting any WordPress issues, you are asked to deactivate all plugins and activate...