Create a WordPress backup and import it again

Would you like to create a WordPress backup? You may have just performed an update, since then your website is no longer accessible? For the future we will show you how to backup your WordPress website and restore your website.

Create WordPress backup and secure website

Creating backups used to be time-consuming and expensive. With today’s technology, data backup is much faster, since antiquarian storage media such as floppy disks have now been replaced by USB sticks and cloud services. The effort to be invested in regular backups is therefore significantly lower.

Basic rules for creating a WordPress backup

To protect your WordPress website should disaster strike, there are three important rules to keep in mind when backing up your website.

1. Regular backups

Creating a backup is not a one-time thing. Establish a regularity for your hedges. This should be based on how often you post new content. To do this, use plugins that create automatic backups for your website. Normally, these only need to be checked.

2. Backup after each update of the WordPress installation

It is recommended to create a backup for your WordPress installation before each update – also for plugins or themes.

3. Use different storage media

Back up your backup to multiple locations at the same time. This can be a hard drive, cloud or USB stick. If the cloud service is not available or the hard drive and USB stick break, you at least have your backup on an intact storage medium.

What is backed up in a WordPress backup?

The backup for your website consists of two areas:

  1. The WordPress website is all files such as images, plugins or the theme itself.
  2. The MySQL database consists of content such as subpages, blog posts, comments and user data.

The two points mentioned include full backup of your website. As already mentioned, a WordPress data backup can be implemented manually or automatically. We present both methods below.

Which backup plugin is recommended?

A popular plugin for creating a backup is “BackWPup” with currently 500,000 active installations and an average rating of 4 out of 5 stars.

BackWPup offers the following functions:

  • Backup of the WordPress database (MySQL)
  • A WordPress XML export
  • Optimizing your database
  • Checking and repairing your database
  • File(s) backup (images, plugins, theme)

The plugin can also be connected to various cloud services such as Dropbox and Google Drive.

Create and schedule WordPress backup

  • You can create a backup plan with the “BackUPup” plugin:
  • Go to “BackUPup” in the backend of your WordPress website
  • Schedule a new backup under “New Job”.
  • Set the output file as “Zip”.
  • Connect “BackUPup” to a cloud service like Google Drive or Dropbox – there is only one for this
  • authentication required
  • Specify an e-mail to which “BackUPup” should send a log
  • You can find your plan under “Tasks”, here you can start the backup by clicking on “Start now”.

Perform a manual WordPress backup

It may happen that for some reason your automated backup solution fails or does not work properly. Manual protection is therefore an alternative. Here we explain how.

First you need access to your FTP server as well as to your MySQL database.

Step 1: Back up the data on your FTP server

Log in to your FTP server with your user data using an FTP client (we recommend Filezilla) and save your WordPress installation including your .htacess file on your hard drive. Your hoster will provide you with the login data.

Step 2: Export WordPress database (MySQL).

Log into your phpMyAdmin via the customer area of ​​your host. Here you can select the database of your WordPress installation. Click on “Export” in the top menu, selecting the format “SQL” and click on “OK”.

Restore WordPress backup

Creating a backup is quick and easy. The tricky part is reloading it, or restoring the WordPress site if it’s corrupted. But don’t worry, basically the same steps are necessary as for creating the backup, just in reverse order. This can happen automatically or manually.

Scenario: The backend of the WordPress website is no longer accessible

If the backend of your WordPress installation is no longer accessible, we suggest a manual recovery.

Import database via MySQL:

  1. Log in to phpMyAdmin with your access data
  2. Select the database of your WordPress.
  3. Now click on “Import” and use the “Browse” function to select the .sql file of the backup.
  4. Normally, the default settings can be retained. However, you should check whether the format “sql” and the character encoding “utf-8” are set.
  5. Now start the import and press “OK”

Import data via FTP

To complete your WordPress recovery, the data such as images, themes, and plugins still need to be uploaded to your web server. The easiest way to do this is with Filezilla, the FTP client we recommend.

  1. Login to your web server via Filezilla.
  2. Now select the secured backup in the left pane of Filezilla
  3. Now drag and drop the backup folder to your server in the right pane.

The Filezilla copying process can take anywhere from a few minutes to an hour, depending on the size of your folder and your internet connection.

Do you have questions about database backup and recovery of your website? CCDM GmbH will be happy to answer any questions you may have. To contact You us!