Beginner’s Guide: How to Restore WordPress from Backup

Do you need to restore WordPress from a backup file? Backups help you restore your website in case something goes wrong. However, restoring WordPress from a backup file is not easy for beginners. In this article, we will show you how to easily restore WordPress… Read More »

The post Beginner’s Guide: How to Restore WordPress from Backup appeared first on WPBeginner.

Do you need to restore WordPress from a backup file? Backups help you restore your website in case something goes wrong. However, restoring WordPress from a backup file is not easy for beginners. In this article, we will show you how to easily restore WordPress from backup step by step.

How to Restore WordPress from Backup

Since this is a lengthy article, we have added table of contents for easier navigation.

Note: This guide is about restoring a WordPress site from backup. If you are trying to move your website to a new domain, then you should check out our guide on moving WordPress to a new domain without losing SEO.

If you are trying to move from localhost to a live web hosting account, then follow this guide on how to move WordPress from local server to live site.

Understanding Backups and Restoring WordPress

There are different ways to create backups for your WordPress site. The best way to create a backup is by using a WordPress backup plugin.

Alternately, you can also create manual backup of your WordPress database and download your WordPress files using FTP.

Restoring WordPress from backups depends entirely on how you created the backup. For example, backups created using BackupBuddy or UpdraftPlus can be restored by using the same plugin. Similarly, manual backups need to be manually restored.

A lot of WordPress users don’t backup their entire websites. Instead, they only backup their theme, uploads directory, and their WordPress database. This reduces their backup size, but increases the steps needed to restore the site.

No matter how you created your backup, the basic steps are the same.

Let’s take a look at how to restore your WordPress site from backup. Since we’re covering different restore methods, please skip to the section that applies to you.

Restoring WordPress from BackupBuddy Backup File

BackupBuddy is a popular premium WordPress backup plugin. If you used BackupBuddy to create backups, then this section is for you.

BackupBuddy offers a very convenient way to restore WordPress from a backup. You need to login to your WordPress website and go to BackupBuddy » Restore/Migrate page.

You will need to download a copy of importbuddy.php file. In the process, you will be asked to provide a password for importbuddy. This password will be used when you restore your website.

Download importbuddy

Next, you need to download a copy of your backup if you haven’t already done so. You can download it from BackupBuddy » Backups or the destination that you used to store your backups.

Once you have the backup zip file and importbuddy.php stored on your computer, connect to your website using FTP.

If you have a complete backup of your website, then delete all files and folders from your server.

However, if you have a partial backup, then you need to first download the files that you haven’t backed up. Once you are sure that you have everything backed up, proceed deleting all files and folders from your website’s root directory.

Delete old WordPress files

Next you need to upload your BackupBuddy backup and importbuddy.php files to your website’s root folder.

Once both files are uploaded to the server, visit importbuddy.php in your web browser. It is in your website’s root directory, so its URL will be something like:

http://www.example.com/importbuddy.php

ImportBuddy will now ask for the password that you created when you downloaded ImportBuddy.

importbuddy password

On the next screen, ImportBuddy will display the backup file you uploaded. In case you did not upload your backup file using FTP, then you can click on the upload tab to upload the backup file now. If you have your backups stored on iTheme’s Stash storage service, then you can connect to it by clicking on stash tab now. Once you have selected your database, click on Next Step to continue.

Select your backup file

ImportBuddy will unzip your backup file and show you a success message when it has extracted the files. Click on the next step button to continue.

On the next screen, ImportBuddy will ask you to provide site URL and database information.

If you are restoring a hacked WordPress website or trying to remove malware, then you do not want to use your old database.

You can either drop tables from your old database using phpMyAdmin, or create a new database using cPanel. Once you are done creating a new database or emptying the old one, provide your database details.

On the other hand, if you are sure your site wasn’t hacked, then you can use the same old database details.

database settings

Click on the next button to continue and importbuddy will now test your database settings and import your data. Once it is done, click next step to continue.

Now ImportBuddy will update your site URLs, paths, etc. After that, you will be asked to test your site. If everything is working fine, then you have successfully restored your website.

Review and cleanup

On the importbuddy page, click ‘Clean up and remove temporary files’ button. This will delete temporary data in database and files created during restoration.

Restoring WordPress using UpdraftPlus Backup

UpdraftPlus is another popular WordPress backup plugin. It allows you to easily backup and restore your WordPress site.

First you need to make sure that you have a complete backup of your WordPress site created by UpdraftPlus. Next, you need to download the backup files to your computer.

If your backups are stored by UpdraftPlus on a remote storage location like Dropbox, Google Drive, etc, then you can download your backup files from those locations to your computer.

Next, you need to connect to an FTP client and delete all WordPress files. After that you need to install WordPress again and login to your website.

You will need to install and activate the UpdraftPlus plugin. Upon activation, visit Settings » UpdraftPlus Backups page and click on the Restore button.

Upload your backup files

Next, you need to click on the ‘Upload backup files’ link and then uplaod the backup files you downloaded earlier.

Uploading backup files

Once your backup files are uploaded, UpdraftPlus will scan those files and will show them on the backups page.

You will need to click on the ‘Restore’ button to proceed.

Restore backup files

This will bring up a popup where you need to click on the restore button again to continue. Make sure that all available backup files such as plugins, database, themes and others are selected.

Restoring backup files

UpdraftPlus will now start extracting and restoring data from those files. Upon success, you will be redirected to the success page.

Backup restored

That’s all, you have successfully restored your WordPress site from an UpdraftPlus backup.

Restoring WordPress Database from Backup using phpMyAdmin

When restoring a manually created backup, you may come across two possible choices. You can either create a new database and import your backup into it, or you can empty your existing database and import backup.

If you are cleaning a hacked WordPress website, then it is very important to change your MySQL username and password before creating a new database or importing into existing database.

To create a new database, login to the cPanel dashboard of your WordPress hosting account and click on the MySQL Databases icon.

MySQL Databases in Cpanel

Next, you will be asked to provide a name for your database and then click on the ‘Create Database’ button.

Create new database

After creating the new database, you need a MySQL user associated with that new database. Scroll down to the MySQL users section and add a new user.

Add new database user

Next, you need to add this user to the MySQL database. Scroll down to ‘Add user to database’ section and select the user along with the database from the drop down menus and then click on the add button.

Add user to db

Now your new database is ready. You can use it to restore your WordPress database backup.

Head over to the cPanel dashboard again and then click on the phpMyAdmin icon.

Launch phpMyAdmin

Next, you need to click on your new database name and then click on the import button.

Importing your database

Click on ‘choose file’ button to select your WordPress database backup file and then click on the go button at the bottom of the page to continue.

PhpMyAdmin will now upload your backup and import it into your database.

You will see a success message upon completion.

That’s all. You have successfully imported your WordPress database. Now the next step is to install WordPress using your new database. If you have already installed WordPress, then add your new database settings into your wp-config.php file, and you will be good to go.

Restoring WordPress Database Backup using cPanel

If you manually created a WordPress database backup using the cPanel on your shared hosting, then you can also restore that database using cPanel.

Log into your cPanel account and under the files section click on Backup.

Backup in cPanel

On the backups page, scroll down to ‘Restore a MySQL database backup’.

Next, click on the choose file button and select the backup file from your hard disk. Once done, click on the upload button.

Restore database using cPanel

Manually Restoring WordPress Files using FTP

If you are restoring WordPress to clean up a hacked site, then you first need to delete all existing WordPress files and directories.

Only do this if your backup is upto date, and you have everything customized, changed, or uploaded on your website.

If you have all your uploads and customizations, then you can safely delete everything on your website using cpanel (way faster) or using FTP.

To delete all files from your website, login to the cPanel of your hosting / VPS hosting and under files section click on the file manager icon.

File manager in cPanel

Go ahead and choose Web root as your directory and proceed. File manager interface will now open in a new browser tab. You will need to select all WordPress files and delete them. This way is much faster.

You can also delete files using FTP, but it’s slower. Simply connect to your website using an FTP client and select all files in your WordPress root directory to delete them.

Delete old WordPress files

Next, you need to download a fresh copy of WordPress from WordPress.org and extract it to your hard disk.

Launch your FTP client and then upload all WordPress files to your server.

Upload WordPress files

Once you have uploaded WordPress files, you can upload wp-config.php file from your backup (only if you are sure that it is clean and not compromised).

Alternately, you can rename wp-config-sample.php file in your freshly uploaded WordPress files to wp-config.php file. After that you will need to edit wp-config.php file and enter your database information.

Don’t forget to save the file and upload it back to your website.

Next, you need to upload other files from your backup. We will recommend that you only upload your images in /wp-content/uploads/ directory.

Once you have uploaded these, visit your website to check that everything is working fine.

Next, you need to login to your WordPress admin area and start installing plugins you had on your site.

Now you can move on to install your theme. If you had customized your WordPress theme or were using a child theme, then you can restore it from backup. However, make sure that those files are clean.

Lastly, go to Settings » Permalinks and adjust permalinks settings to match your site and then update permalinks.

Troubleshooting WordPress Backup Restore Issues

There are some common problems that you may come across when restoring your WordPress website. We have separate guides for each of them.

Things to do After Restoring your WordPress Site

Once you have successfully restored your website, we strongly recommend that you improve your website security.

If you haven’t done so already, please make sure that you have a regular WordPress backup with one of these WordPress backup plugins.

For securing your website, we will recommend that you immediately change your WordPress password. If you are running a multi-user website, then ask all users to update their passwords immediately.

You can also install a website firewall. At WPBeginner, we use Sucuri to monitor and strengthen security of our website. It monitors for security threats, and they also offer malware removal service with their subscription plans. See how Sucuri helped us block 450,000 attacks in 3 months.

We hope this article helped you learn how to restore WordPress from backup. You may also want to see our ultimate step by step WordPress security guide for beginners.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

The post Beginner’s Guide: How to Restore WordPress from Backup appeared first on WPBeginner.

7 Best WordPress Backup Plugins Compared (Pros and Cons)

Creating regular WordPress backups is the best thing you can do for your website. Backups give you peace of mind and can save you in catastrophic situations when your site gets hacked or you accidentally lock yourself out. There are several free and paid backup… Read More »

The post 7 Best WordPress Backup Plugins Compared (Pros and Cons) appeared first on WPBeginner.

Creating regular WordPress backups is the best thing you can do for your website. Backups give you peace of mind and can save you in catastrophic situations when your site gets hacked or you accidentally lock yourself out. There are several free and paid backup plugins for WordPress, and most of them are fairly easy to use. In this article, we will show you the 7 best backup plugins for WordPress.

Best WordPress Backup Plugins Compared

Important: Many WordPress hosting providers offer limited backup services, but please remember that it is your responsibility to backup your website on your own. Do not rely solely on your hosting provider for backups.

If you are not already backing up your site, then you should pick one of these 7 best WordPress backup plugins and start using it right away.

1. BackupBuddy

BackupBuddy

BackupBuddy is the most popular premium WordPress backup plugin. It allows you to easily schedule daily, weekly, or monthly backups. It can also automatically store your backups in Dropbox, Amazon S3, Rackspace Cloud, FTP, Stash (their cloud service), and even email it to yourself.

If you use their Stash service, then you also have the ability to do real-time backups.

The biggest advantage of using BackupBuddy is that it is not a subscription based service, so there is no monthly fee. You can use the plugin on the number of sites mentioned in your plan. You also get access to premium support forums, regular updates, and 1GB of cloud storage to store your backups.

You can even use BackupBuddy to duplicate, migrate and restore websites.

2. UpdraftPlus

UpdraftPlus

UpdraftPlus is a free WordPress backup plugin. It allows you to create complete backup of your WordPress site and store it on the cloud or download to your computer.

The plugin supports scheduled as well as on-demand backups. You can also choose which files to backup. It can automatically upload your backups to Dropbox, Google Drive, S3, Rackspace, FTP, SFTP, email, and several other cloud storage services (see our step by step guide on how to backup & restore your WordPress site with UpdraftPlus).

UpdraftPlus also has a premium version with add-ons to migrate or clone site, database search and replace, and multisite support among other things. The premium version also gets you access to priority support.

3. BackWPUp

BackWPUp

BackWPup is a free plugin that allows you to create complete WordPress backup for free and store it on the cloud (Dropbox, Amazon S3, Rackspace, etc), FTP, email, or on your computer.

It is extremely easy to use and allows you to schedule automatic backups according to your site’s update frequency.

Restoring a WordPress site from backup is also very simple. The BackWPup Pro version comes with priority support, ability to store backups on Google Drive, and some other cool features.

4. BackUpWordPress

BackUpWordPress

BackupWordPress is a complete WordPress backup plugin with automatic scheduling support. It allows you to create different schedules for your database and files. The only problem is that the free version does not allow you to store your WordPress backups to a cloud storage service.

If you want to store your backups on Dropbox, Google Drive, FTP, etc, then you will need to purchase a premium extension for it. The extensions are available for each service, and you can buy the one you need or the whole bundle.

5. Duplicator

Duplicator

As the name suggests, Duplicator is a popular WordPress plugin used to migrate WordPress sites. However it also has backup features.

It does not allow you to create automated scheduled backups which makes it less than ideal primary WordPress backup solution for a regularly maintained site.

6. WP-DB-Backup

WP-DB-Backup

With more than 400,000 active installs, WP-DB-Backup is one of the most popular WordPress backup plugins. The only problem is that it only backups your WordPress database.

This means that you will have to backup your media files manually. If you do not update a site too often or do not upload images, then you can use WP-DB-Backup as your primary WordPress backup plugin.

WP-DB-Backup makes it really simple to create database backups, schedule automated backups, and restore your database. It is also a very useful tool for users who do not have access to phpMyAdmin to backup WordPress dataabase manually.

7. VaultPress

VaultPress

At WPBeginner, we use VaultPress to backup our site. VaultPress was founded by Matt Mullenweg (WordPress co-founder) and his team at Automattic.

It has recently become part of Automattic’s another product called JetPack. You will need a JetPack subscription plan to use VaultPress. There are different pricing plans with different set of features.

VaultPress offers automated real-time cloud backup solution starting at $3.50 per month. Setting up VaultPress and restoring from backups is just a matter of clicks. With some of their packages, they even offer security scans.

There are a few downsides of using VaultPress. First, it is a recurring expense that can add up if you have multiple WordPress sites. Secondly, you will have to subscribe to JetPack, get a WordPress.com account, and install JetPack plugin on your site.

Lastly, on the lower plans backups are only stored for 30-day archive. If you want unlimited backup archive, then you have to pay the $29 per month fee per website which is significantly expensive for beginners.

We are still using VaultPress because we got grandfathered in at their older pricing which was a lot more favorable.

Final Thoughts

Each WordPress backup plugin has it’s pros and cons. We use VaultPress for two main reasons. It is extremely easy to use, and it offers real-time incremental backups. What this means is that instead of backing up all of your files every day or every hour, it only creates a backup of what has been updated literally within minutes of the update. This is ideal for a large sites like ours because it allows us to use our server resources efficiently.

However if you run a small to medium size website and hate paying monthly fees, then we recommend the popular BackupBuddy plugin. Why? Because they have their own cloud storage, Stash, which makes it easy for beginners to store their backups in cloud with a matter of few clicks.

Whichever WordPress backup plugin you end up choosing, please do NOT store your backups on the same server as your website.

By doing that, you are putting all of your eggs in one basket. If your server’s hardware fails or worst you get hacked, then you don’t have a backup which defeats the purpose of setting up regular backups.

This is why we highly recommend storing your backups on a third-party storage service like Dropbox, Amazon S3, Google Drive, etc.

That’s all. We hope that this list helped you pick the best WordPress backup plugin for your site. You may also want to see our step by step WordPress security guide for beginners.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

The post 7 Best WordPress Backup Plugins Compared (Pros and Cons) appeared first on WPBeginner.

How to Backup & Restore Your WordPress Site with UpdraftPlus

Backups are the first layer of security for any WordPress site. Aside from having automated backups, you also need to have an easy way to restore the backup if needed. In this article, we will show you how to easily backup and restore your WordPress… Read More »

The post How to Backup & Restore Your WordPress Site with UpdraftPlus appeared first on WPBeginner.

Backups are the first layer of security for any WordPress site. Aside from having automated backups, you also need to have an easy way to restore the backup if needed. In this article, we will show you how to easily backup and restore your WordPress site with UpdraftPlus.

UpdraftPlus

Why You Need a Backup & Restore Solution for WordPress?

Research shows that data loss and downtime cost $1.7 trillion each year to the globally economy.

All websites on the internet are vulnerable to data loss and security threats. As a website owner, these are some common scenarios when you may lose your data:

  • Your website can get hacked and hackers may destroy your data.
  • Your hosting provider can lose your data
  • Your host reserves the right to terminate your account and delete all your data.

There are many other scenarios where you could end up losing your website and all the valuable data created over the years.

The best way to protect yourself against these threats is to regularly backup your WordPress site.

WordPress does not come with a built-in backup solution. However, there are several great WordPress backup plugins which allow you to automatically backup and restore your WordPress site.

UpdraftPlus is one of the best WordPress backup plugins. It allows you to setup automatic backup schedules. It will also help you restore your WordPress site in case something bad happens.

Having said that, let’s take a look at how to easily backup and restore your WordPress site with UpdraftPlus.

Creating WordPress Backup with UpdraftPlus

First thing you need to do is install and activate the UpdraftPlus plugin. For more details, see our step by step guide on how to install a WordPress plugin.

Upon activation, you need to visit Settings » UpdraftPlus Backups page to configure plugin settings.

Settings page UpdraftPlus

Now you need to click on the settings tab.

This is where you will set up an automatic backup schedule and a remote location to store your backups.

UpdraftPlus settings

First you need to choose a backup schedule for your files. Files include your WordPress themes, plugins, images and other uploads.

After that you need to select a backup schedule for your WordPress database. WordPress is a database driven software. All your posts and pages, comments, website settings, are stored in the database.

Your backup schedule should be based on how often you add new content to your website.

For example, If you add two blog posts each week, then you can select a fortnightly backup of files and weekly backup of database.

Next, you need to choose where to store your backup files.

It is a bad idea to save your backups on the same location as your website. Losing your website, means you will also lose access to your backup files.

This is why you need to choose a remote cloud storage service to store your backups.

UpdraftPlus allows you to save your backups to several cloud storage services including Dropbox, Google Drive, Microsoft OneDrive, any many others. You can also send your backups to an email address.

Simply click on a remote service to select it, and you will see setup instructions below.

For the sake of this tutorial, we will show you how to use Dropbox as your remote backup storage service with UpdraftPlus.

We will go ahead and click on Dropbox to select it and then scroll down to the bottom of the page and click on the save changes button.

UpdraftPlus will save your settings. However, you still need to give UpdraftPlus access to your Dropbox account.

Scroll down to remote storage setup instructions and click on the link next to ‘Authenticate with Dropbox’ option.

Setting up Dropbox as your remote storage service for backups

The link will take you to the Dropbox website where you will be asked to sign-in using your Dropbox email and password.

After login, you will be asked if you want to allow UpdraftPlus to access your Dropbox account.

Allow UpdraftPlus to access Dropbox

UpdraftPlus will only have permission to access its own folder in ‘Apps » UpdraftPlus” folder. Click on ‘Allow’ button to continue.

You will be redirected to UpdraftPlus website where you need to click on ‘Complete Setup’ button to finish setup.

Complete setup

You will now be taken back to your WordPress site, and you will see the UpdraftPlus settings page again. Scroll down to the bottom of the page and click on the Save Changes button.

You have now setup backup schedule and remote location to store your backups.

Creating Manual WordPress Backups with UpdraftPlus

UpdraftPlus can automatically create backups based on the schedule you selected earlier. However, you can also manually create backups any time you want.

First you need to visit Settings » UpdraftPlus Backups and click on ‘Backup Now’ button.

Creating a manual backup with UpdraftPlus

This will bring up a pop-up with options to select files/database backup and whether you want to send the backup to remote storage. (see which WordPress files should you backup?)

Manual backup

Click on the ‘Backup Now’ button to continue.

UpdraftPlus will now start creating backup of your files and database. You will be able to see the progress on the settings page.

Backup Progress

The process may take a while depending on the size of your website.

UpdraftPlus will also start uploading your backup files to the remote location.

Restoring Your WordPress Backup with UpdraftPlus

Creating backups is easy, but the real useful part about backups is the ability to restore them with the same ease.

UpdraftPlus makes it easy to restore your WordPress site from a backup.

If your WordPress site was hacked or you want to start fresh, then first you will need to delete everything and install WordPress again.

Next, you will need to install and activate the UpdraftPlus plugin again on your fresh new WordPress site.

Upon activation, you need to visit Settings » UpdraftPlus Backups page and click on Restore button.

This will bring you to the backups page. UpdraftPlus will scan your server to see if it can find an existing backup in /wp-content/updraft/ folder on your website.

However, since you deleted everything from your website it will not be able to find the backup files.

If you saved the backup files on your computer, then you can click on ‘Upload backup files’ link to manually upload and restore them.

Upload backup files manually

You can also connect UpdraftPlus to remote location (Dropbox, Google Drive, etc). This way UpdraftPlus will be able to scan remote location and use your previously stored backups.

Click on the Settings tab and then choose the remote location you used earlier to store your backups.

Reconnect remote storage location

Follow the instructions to authenticate your website with the remote storage service.

Don’t forget to click on the ‘Save Changes’ button at the bottom of the page to restore your settings.

Now you can switch back to ‘Existing Backups’ tab and click on the ‘Rescan remote location’ link.

Remote backups

UpdraftPlus will now look for backups in the remote storage location and display them below.

You can now click on the restore button next to a backup.

UpdraftPlus will now ask you what you would like to restore. You need to select all options and then click ‘Restore’ button.

Restore options

UpdraftPlus will now fetch your backup files from the remote location and start restoring your site from the backup.

Our UpdraftPlus Review

UpdraftPlus is a powerful WordPress backup plugin, and it’s a great option for DIY users who want the flexibility to choose their backup schedule and remote storage location.

Because UpdraftPlus is free, it’s a popular choice among users. However you can upgrade to UpdraftPlus Premium to access premium addons such as Website Migrator, UpdraftVault, priority support, and molre options. The premium option costs $70 per year.

However like most WordPress backup plugins, UpdraftPlus lacks the ability to do realtime backups of your website.

If you want real-time backups, unlimited storage, and don’t want to pay a third-party storage service like Dropbox, then we recommend using VaultPress instead. This is what we use on WPBeginner.

The downside of VaultPress is cost. The real-time backup plan for one site costs $165 per year which is more than twice UpdraftPlus premium which gets you access for two sites and obviously a non-comparison with the free version.

Final Thoughts

Backups allow you to recover your website in an emergency. However, they cannot protect your website against common security threats like hacking, malware, code injection, etc.

At WPBeginner, we use Sucuri to protect our site (see how Sucuri helped us block 450,000 WordPress attacks).

You need to make sure that your WordPress site is secure. Follow the instructions in our ultimate WordPress security guide to strengthen your WordPress security.

That’s all, we hope this article helped you easily backup and restore WordPress sites with UpdraftPlus.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

The post How to Backup & Restore Your WordPress Site with UpdraftPlus appeared first on WPBeginner.

How To Make a WordPress Database Backup Manually

Do you want to know how to make a WordPress database backup manually without using a plugin? Knowing the manual method allows you to quickly create a database backup whenever you need it. In this article, we will show you how to make a WordPress… Read More »

The post How To Make a WordPress Database Backup Manually appeared first on WPBeginner.

Do you want to know how to make a WordPress database backup manually without using a plugin? Knowing the manual method allows you to quickly create a database backup whenever you need it. In this article, we will show you how to make a WordPress database backup manually.

WordPress Database Backup Manually

When and Why Make a WordPress Database Backup Manually

You should always install and setup a WordPress backup system for your site. This allows you to restore your site should something go wrong.

Many users lose access to their WordPress admin area after a hack attempt or some plugin error. In these cases, most tutorials recommend that you create a complete WordPress backup.

However, since you cannot access the admin area, it would be hard for you to use a plugin for backups. This is where knowing how to make a WordPress database backup manually comes in handy.

A manual database backup is exactly the same as the database backups created by a plugin.

Having said that, let’s take a look at how to easily make a WordPress database backup manually.

Backing Up WordPress Database Manually Using phpMyAdmin

For this method we will be using PhpMyAdmin. It is an open source software that allows you to manage your MySQL database using a web based interface. It comes pre-installed on most WordPress hosting providers.

First you need to login to your WordPress hosting control panel. Upon login, click on phpMyAdmin under the database section.

phpmyadmin

This will launch phpMyAdmin window. Make sure your WordPress database is selected inside phpMyAdmin. If it isn’t, then click on your WordPress database name to select it. You will be able to see the list of WordPress database tables when it is selected.

Once your database is selected, click on Export link from the top menu bar.

phpMyAdmin Export Button

You will be asked to select the export method. You need to select custom as it will give you more options to explore.

phpMyAdmin Export Method

Clicking on custom will reveal more options. First it will show all your tables in your WordPress database as selected.

Sometimes WordPress plugins add their own tables to your database. If there are any tables that you would like to exclude from export, then you can deselect them. If you are unsure, then it is better to keep them all selected.

phpMyAdmin Custom Export

Scroll down to the output section. By default, phpMyAdmin will show you the output of the export process as text. You need to change that by selecting ‘Save output to a file’ option. For compression you need to select zipped or gzipped option.

Now you need to scroll down to the bottom of the page and click on the ‘Go’ button.

PhpMyAdmin will now send you the database export as zip or gzip file.

That’s all, you have successfully made a manually WordPress database backup.

Creating a Manual WordPress Database Backup from cPanel

Most good WordPress hosting companies also offer easier ways to download on demand backups. Here is how you can use that to make a manual WordPress database backup.

Simply login to your hosting control panel and scroll down to the files section where you will see the Backup button. Bluehost, SiteGround, and HostGator all have similar options.

On the backups page, scroll down to partial backups section and click on your database name to download your database backup file.

Download a WordPress database backup using cPanel

You can also download your WordPress files backup from this page if you need to.

Editor’s Note: You can make WordPress database backups manually, but keep in mind that it is not an alternative to a proper backup solution for your WordPress site.

There are situations when you may not have access to your WordPress database at all. Like if your hosting company suspends your account, or loses your data.

Another possible scenario is when some hacker has injected data in your WordPress database, cleaning an infected database would be a lot more difficult.

Use a proper backup plugin to automatically store your WordPress database backups on the cloud. We recommend using BackupBuddy, it automatically creates and stores your backups on a cloud storage service like Google Drive, DropBox, or Stash.

See our guide on how to keep your WordPress content safe with BackupBuddy for detailed instructions.

That’s all, we hope this article helped you learn how to make a WordPress database backup manually. You may also want to see our guide on how to restore your WordPress site with just a database backup.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

The post How To Make a WordPress Database Backup Manually appeared first on WPBeginner.

How to Keep Your WordPress Content Safe with BackupBuddy

BackupBuddy is an automated full-site WordPress backup plugin that keeps your WordPress content safe by creating database backups and core files as well.

The post How to Keep Your WordPress Content Safe with BackupBuddy appeared first on WPBeginner.

Are you looking for a reliable backup plugin for your WordPress site? Whether you run a small personal blog or a business website, we highly recommend that you setup an automated backup solution for your WordPress site. In this article, we will show you how to keep your WordPress content safe with BackupBuddy.

Keeping WordPress safe with BackupBuddy

Why You Need a WordPress Backup Plugin for Your Site

All websites on the internet are vulnerable to security threats. Any website can fall prey to hackers, data loss, or server disasters.

This could happen to anyone, whether you are using a WordPress site or not. Anyone with experience can tell you the question is not if it will happen, it is when it will happen.

The first step to protect yourself against such disasters is by implementing an automated backup solution.

Just like your computer, you can backup your website and store backups on separate locations. This allows you to easily recover your website when you need it.

If you do not update your website on a regular basis, then you can probably create a manual database backup and download your WordPress files. However, if you regularly update your site, then it wouldn’t be possible to always keep your backups up to date.

This is where BackupBuddy comes in. It is a WordPress backup plugin, which allows you to automatically create complete backups of your WordPress site and save them on multiple remote locations like a cloud storage service, your computer, FTP server, etc.

Installing BackupBuddy on Your WordPress Site

First you will need to purchase the BackupBuddy plugin. The pricing starts from $80 which gives you access to 1 year of plugin updates and support, 1 GB of cloud storage on Stash, Stash live, and you can use it on 2 sites.

After purchasing the plugin, you need to download it to your computer.

Next, you need to install and activate the BackupBuddy plugin. For more details, see our step by step guide on how to install a WordPress plugin.

Upon activation, you’ll need to add your BackupBuddy license before you can get automatic updates to the latest versions. The plugin will show you a link to the licensing page.

Links to licensing page

You can also visit the page by clicking on Settings » iThemes Licensing.

iThemes licensing page

Simply enter your iThemes username and password and click on the license products button to continue. Upon successful verification, you license will be activated.

Setting Up Real Time Backups with BackupBuddy and Stash Live

Your BackupBuddy plugin gives you access to Stash Live. It is BackupBuddy’s real-time backup storage system.

With real time backups, changes to your WordPress posts, pages, media, themes, and plugins will be automatically stored in your Stash live cloud storage.

This ensures that you always have the latest and most up to date backup of your site. Stash Live also makes it super easy to restore your website with just one click.

Simply visit BackupBuddy » Stash Live page in WordPress admin area and fill in your iThemes username and password.

You also need to provide an email address where you want to receive new backup notifications. These emails will contain a link to the zip downloads.

Login to Stash Live

Click on ‘Save settings and start backup’ button to continue.

BackupBuddy will now start creating your first backup and upload it to your Stash account. You will be able to see the backup progress on your screen.

Backup Progress for Stash Live

Since this is your first Stash live backup, BackupBuddy will create and upload the complete backup. This can take few minutes to few hours, depending on how much data you have on your site.

Leaving the progress screen will not disrupt the backup. You can do other things on your WordPress site and backup will continue running in the background.

Once it’s finished, you will receive an email notification. You will also see the backup files as snapshots on Stash Live page.

You can leave those snapshots on Stash Live. You can also download these snapshots to your computer or move them to your own server with one click at anytime.

Stash live Snapshots

Setting up Scheduled Backups with BackupBuddy

Stash Live allows you to have the most up to date backups of your WordPress site with real time backups.

However if you don’t want to use Stash live, then there are plenty of other ways to backup WordPress with BackupBuddy.

Simply visit BackupBuddy » Backup page to create and setup backups.

BackupBuddy quick setup wizard

First you need to provide an email address. This is where BackupBuddy will send you email notifications and backup emails.

Next you need to provide a password. This password will be used if / when you are moving your WordPress site to a new server or host using BackupBuddy.

Once you have set your password, then you need to choose where to send your backups.

There are a number of options available. You can store your WordPress backups in dropbox, Google Drive, Amazon S3, BackupBuddy’s Stash storage, among other options.

Choose where to save backups

Lastly, you need to select how often you want to create backups. You can create manual backups on demand, or select a monthly or weekly full backup option with daily database backups.

Click on the Save Settings button to continue.

BackupBuddy will now show you the backup profiles page. You can click on Database or Complete Backup profiles to create your first backup.

Backup Profiles

Since you haven’t created backups before, we recommend you to click on full backup profile.

Make sure you check the box next to ‘Send to remote destination as part of backup process’ option. This will bring up a popup from where you can select one of the destinations you added earlier.

Select backup destination

BackupBuddy will start creating your backup files. You will be able to see the progress of the backup. Once it is finished, you will see a success message.

You can now check your chosen remote destination to make sure that your backup was successfully transferred.

Restoring a WordPress Backup with BackupBuddy

BackupBuddy not only makes it easy for you to create backups, it also lets you restore your site from backups just as easily.

Simply go to BackupBuddy » Restore/Migrate page and scroll down to your backup section. There you will see the link to browse or restore files and database rollback.

Restore files and database from backup

For a full restore, you will need to download and upload importbuddy.php file to your server. See detailed instructions in our guide on how to restore WordPress from backup.

We hope this article helped you keep your WordPress content safe with BackupBuddy. You may also want to see our beginner’s guide on fixing your hacked WordPress site.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

The post How to Keep Your WordPress Content Safe with BackupBuddy appeared first on WPBeginner.

How to Setup Automatic WordPress Backup with CodeGuard

Do you want to create a time machine for your website? Having an automatic cloud backup of your WordPress site is the first step in securing your website because it gives you the option to revert changes should anything go wrong. In this article, we… Read More »

The post How to Setup Automatic WordPress Backup with CodeGuard appeared first on WPBeginner.

Do you want to create a time machine for your website? Having an automatic cloud backup of your WordPress site is the first step in securing your website because it gives you the option to revert changes should anything go wrong. In this article, we will show you how to setup an automatic WordPress backup with CodeGuard along with sharing our honest CodeGuard review, so you can make an educated decision.

Setting up WordPress Backup Using CodeGuard

What is CodeGuard?

CodeGuard is a website backup service that can automatically backup your WordPress site and save it on the cloud. It also allows you to track your changes daily.

There are plenty of WordPress backup plugins available, and we have created a list of the best WordPress backup plugins.

However, using a plugin means you will have to keep it up to date, and in most cases the backups aren’t stored properly on an offsite location.

If you are managing client websites, then managing all backups separately is quite difficult. Not to mention that clients can accidentally turn off backups.

CodeGuard is a paid backup service that works on all website platforms including WordPress. Their monthly plans start from $5/month for 1 site and unlimited databases with up to 5GB storage. They also offer a free 14 day trial on all their plans.

We decided to give CodeGuard a try because it makes a bold claim of being “a time machine for your website”. In this CodeGuard review, we will put that claim to test.

Let’s start with setting up WordPress backups through CodeGuard.

Setting up WordPress Backup on CodeGuard

First thing you need to do is visit CodeGuard website and click on Start Your Free Trial button.

Start your free trial by clicking on the signup button

This will bring you to the signup form. Fill it out and click on ‘start my free trial’ button. You will be asked to enter a password for your account.

It’s essential that you use a strong password (See how to manage passwords guide for WordPress users), and then click on the next step button.

Enter password for your account

This will bring you to the add website page. First you need to enter your website’s URL and then provide your FTP information.

Adding your website's FTP or SFTP information

If you do not know your FTP username or password, then please contact your WordPress hosting provider. You can also find this information in the email your WordPress hosting provider sent you when you signed up. Alternately, you can also locate this information using cPanel by clicking on FTP or FTP manager.

After entering your FTP/SFTP information, click on the test connection button. CodeGuard will show a success message. You can now click on the connect your website button.

Connect website

CodeGuard will connect to your website, and it will show you all the files stored on your server.

You will need to select the folder that contains all your WordPress files and then click ‘select root directory’ button to continue.

Select root directory

Now scroll down a bit, and you will see ‘Select website content’ section. You need to select all your files and folders.

Simply click on the top folder and all the files inside it will be automatically selected. Next, click on the begin first backup button to continue.

Select website content

You will see a success message. CodeGuard will automatically start downloading your WordPress files to their cloud servers in the background.

You will be asked to add your WordPress database for backup.

Files added successfully

The next step is to connect your database and to do that you will need the following information.

  • Your database hostname or IP address
  • MySQL username
  • MySQL user password

You can find this information in your WordPress website’s wp-config.php file itself. Alternatively, you can contact your web host to provide you this information.

If you connect to your host using localhost as your hostname, then you will need to enter your domain name as the hostname.

On the other hand, if you use a hostname like mysql.example.com, then you will have to enter that or add your MySQL server’s IP address.

Add database

Enter your database connection information. Before you click on the next step button, you will need to copy the IP addresses shown under the Helpful Tips box on the right.

Your web host will not allow an external IP to connect to your database unless you explicitly allow it access. To do that, you need whitelist these IP addresses.

Simply login to your cPanel account and click on the Remote MySQL icon.

Remote MySQL in cPanel

Copy and paste an IP address and then click on add host button. Repeat for all IP addresses given by CodeGuard.

Once you are done, come back to the CodeGuard’s add database screen and click on the next step button.

CodeGuard will connect to your database now. If you have more than one database, then it will ask you to select one. Choose your WordPress database and click on add database button.

CodeGuard will now start backing up your database to their cloud servers. Upon completion it will show your database and some basic WordPress stats.

Database backed up

That’s all you have successfully backed up your WordPress site and database on CodeGuard’s cloud servers.

How to Restore Site and Database from CodeGuard Backups

As a website owner, you need to be sure that the backup solution you are using for your site is easy to restore. CodeGuard offers automatic restore options which allow you to restore your WordPress files and database with one click.

Site restore from backups on CodeGuard

You can also download your backups to your own computer to perform a manual recovery.

CodeGuard Review

CodeGuard really measures up to the claim of being a time machine for your website. Using the FTP / MySQL method, you can backup just about any website including WordPress and your other sites.

We always recommend storing your backups on third-party cloud servers which makes CodeGuard an ideal backup solution for anyone starting out.

While having backups is a choice, we strongly recommend that you have one vs not. We’ve had too many users whose sites were hacked, and they had no backup (which means literally losing years of content).

Regular site backups are the best insurance policy you can purchase for your web based business.

We strongly recommend that you use a WordPress backup solution, and CodeGuard is definitely among the top of our list.

See the full list of our recommended WordPress backup plugins.

That’s all. We hope this article helped you setup automatic WordPress backups with CodeGuard and you found our CodeGuard review helpful. You may also want to see our guide on 11 things to do before launching a WordPress site.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

The post How to Setup Automatic WordPress Backup with CodeGuard appeared first on WPBeginner.

How to Restore a WordPress Site with Just a Database Backup

We always recommend our users to make complete WordPress backups on a regular basis. But what if you unknowingly used one of the free plugins that only make database backups? In this article, we will show you how to restore a WordPress site with just… Read More »

The post How to Restore a WordPress Site with Just a Database Backup appeared first on WPBeginner.

We always recommend our users to make complete WordPress backups on a regular basis. But what if you unknowingly used one of the free plugins that only make database backups? In this article, we will show you how to restore a WordPress site with just a database backup. It will not be a complete restore, but we will show you how you can minimize the damage.

Recovering a WordPress site from a database backup alone

Getting Started

For the sake of this tutorial, we are assuming that you have your WordPress database backup in a zip file. If you do not have one yet, here is how to make a WordPress database backup manually.

If you are recovering from a bad experience with your web hosting provider, then it is probably the time to find a better host. We have hand picked some of the best WordPress hosting providers. These are the companies that we have worked with and trust with our own projects.

Also see: 7 Key Indicators when you should switch your WordPress hosting.

Preparing to Restore WordPress Database Backup

First, you will need to create a new database. Simply login to your cPanel account and click on MySQL Databases under the Database section.

MySQL databases in cPanel

Next, provide a name for your database and then click on create database button.

Creating new MySQL database

Now that you have created a database, you need a MySQL user who will be assigned all privileges to work on your newly created database.

On the same MySQL databases page, scroll down to MySQL users section and add a new user.

Adding a new MySQL user

Provide a username and a strong password for your database user and then click on create user button.

Next, you need to add this user to the MySQL database. Scroll down to ‘Add user to database’ section and select the user along with the database from the drop down menus and then click on the add button.

Adding a user to database

Your new database is now ready for WordPress.

Importing WordPress Database Backup

First you need to visit the cPanel dashbaord. Under the databases section, you need to click on phpMyAdmin.

Launching phpMyAdmin from cPanel

On then next step, select the database you created earlier on the phpMyAdmin page and then click on the Import button.

Now you need to click on the choose file button to upload your WordPress database backup file. Simply click on the go button at the bottom of the page to start importing.

importdb

You will see a success message when the import job is finished.

You have successfully imported your WordPress database. Now the next step is to install WordPress using your new database.

Restoring Your WordPress Site

For a manual restore of WordPress, you will need to manually install WordPress on your server. Visit our step by step WordPress installation tutorial and jump to the section ‘how to install WordPress using FTP’ for detailed instructions.

During the installation, when you reach ‘create a configuration file’ step. Enter the database name and user you created earlier.

Creating configuration file step during WordPress installation

You will now see a message that WordPress can connect to your database, and you can run the installation now.

Clicking on the install button will now show you the ‘Already Installed’ message.

Already installed message

That’s all you can now proceed to login to your WordPress site.

Restoration Troubleshooting

Since you do not have your old WordPress files, there will be several things missing. Some of them can be easily restored while others will be a bit difficult. We will go through all of them one by one.

1. Theme

Simply install a fresh copy of your old WordPress theme. If you made direct changes to your theme files, then all those changes will be gone.

You will have to go through theme options to set it up the way it was before.

2. Widgets

Widgets play an important role in WordPress themes. Luckily, they are stored in your WordPress database and switching to your old theme will restore some of your widgets.

You can always go to Appearance » Widgets to add and rearrange widgets in your sidebars.

Some WordPress plugins come with their own widgets. In order to use those widgets, you will first need to install and activate those plugins.

3. Permalinks

Your site’s permalink structure is also stored in database, and it will be automatically restored. However, if you are seeing 404 errors on front-end of your site, then you need to refresh permalink settings.

Simply go to Settings » Permalinks and click on the save changes button without changing anything. This will refresh your WordPress url structure.

4. Plugins

WordPress stores a record of your site’s active plugins. When you visit the plugins page for the first time, WordPress will show you a list of errors for each plugin that was in the database but is not installed anymore.

Deactivated plugins

Copy all the plugin names and start installing and activating them one by one.

Recovering Lost Images for your WordPress Site

Finding and replacing lost images on your website would be the trickiest part of the recovery. Depending on how much content and images you have, this can take a long time.

Unfortunately, there is no easy way around it. You will have to use a variety of tools to extract your images from different sources. Your chances of recovering all images are fairly low.

1. Look in Your Browser Caches

If you have recently lost your website, then you can look into your browser cache.

Firefox users can download CacheViewer2 add-on to easily find images from their website stored in browser cache.

Finding cached images in Firefox

You can just right click on an image and select save as from the menu.

Google Chrome users on Windows can try Chrome Cache Viewer.

Google Chrome users on Mac will be out of luck. We were unable to find any reasonable solution to browse, preview, and save image from Google Chrome cache on Mac.

2. Look for Your Images in Web Caches

There are several web services that keep cached versions of websites. You can start by looking for your images in Google’s image search. Simply enter your site’s URL and you will be able to see images Google found on your website.

Finding your images in Google Image search

You can click on an image to see a larger preview and save the image.

If you are restoring a much older site and can’t find images on Google or Bing, then you can try Archive.org. It is a non-profit organization that stores snapshots of websites for historical purposes.

Internet Archive Way Back Machine

Finding and Replacing Images on Your Website

If you did not have much content on your old site, then you can manually replace images in your posts. However, if you have a lot of content then finding and replacing images manually will be difficult.

Here is how you can easily locate broken images and replace them.

First, you need to install and activate the Broken Link Checker plugin. Upon activation, simply go to Tools » Broken Links Checker page. The plugin will show you a list of all broken links on your site.

Find and replace missing images in WordPress

Broken images are also considered broken links, so they will appear in the list as well. You can click on the link text column to sort the broken links list to show images first.

Now you can replace the images that you have recovered by editing posts. For the images that you were not able to recover, you can either try to recreate them or simply unlink them.

Bonus Tip

It will be hard to recover all your lost data. Your site may even show errors and affect user experience. This is why you see many experts strongly urging you to set up automatic backups.

We recommend using BackupBuddy. It is a premium WordPress backup plugin with easy restore options and the ability to automatically create and save your backups on the cloud.

That’s all, we hope this article helped you restore your WordPress site from database backup. You may also want to see our list of 13 vital tips and hacks to protect your WordPress admin area.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

The post How to Restore a WordPress Site with Just a Database Backup appeared first on WPBeginner.