Loading
Cancel
Webmail Login
Control Panel Login
How to backup your website and MySQL Database
.CO.UK ONLY £5.33
Find your perfect domain here

How to backup your website and database

How to backup your website

The below guide will show you how to backup your website's files and any databases you have using Squirrel Hosting's 1 click backup feature. With this backup, you can restore your website's files or databases with a few clicks should anything happen.

We strongly suggest making a backup at least once every month. We do have backups on our server but these are snapshot backups and are used to restore a whole server (not an individual site). As such, it is your responsibility to be able to restore your website should your site stop working (e.g. if your site gets hacked due to a lack of security on your part etc).

The below guide is split into 4 sections;

  • How to backup your website files.
  • How to backup your databases.
  • How to restore your website's files.
  • How to restore your databases.

All of the below steps assume you have logged into your eXtend control panel for the hosting package you want to backup. If not, log into your account by clicking 'control panel' above then click 'manage web hosting' and finally 'load eXtend control panel'.

TIP : Remember you can restore your database without having to restore your website files. This can be handy if you have run a MySQL injection (e.g. for a Prestashop module) and damaged the database but not the site's files.

Backing up your website

Back up your website's files

This step will backup all the files on your hosting package. If your website is a dynamic website which uses a database (e.g. Wordpress or Prestashop) then you will also need to do step 2 to backup the database.

In eXtend click the 'Backup / Restore' icon.

Backup Website

Next click 'Create Full Backup'.

Create full backup

You should be asked to save a file to your computer. This is all of your websites files so make sure to save it somewhere safe!

Back up your MySQL databases

Click the MySQL (or MySQL) database icon.

mssql

Click the backup button next to the database you want to back up and when prompted save the file to your computer. If you have more than one database you will need to repeat this step.

Restore your website

How to restore your website's files.

Click the 'backup / restore' icon under the Files box.

Backup Website

On the next page, scroll down to the 'Restore a backup' section and you will be presented with two options - Upload your backup or specify the backup location.

If the backup you made earlier is over 5mb then you may find it easier to upload the backup via FTP and specify the file in the FTP box.

Otherwise, click the 'Choose File' button and select your backup file.

Choose backup file

You now need to inform the system how you want it to run the backup. You have three options here:

  • Delete all files and restore the zip file. This will delete all the files on the server and restore the ones in your backup.
  • Recreate missing files only. This will try to restore the files which are in your backup but not on the server.
  • Uncompress all files into a temporary directory. This will uncompress the backup into a folder of your choice.

In this example we will choose to delete all the files and restore from the backup.

Choose Restore Type

Once you have selected which option you want, click the 'Start Restore' button. This will now upload your backup. This may take a while if your file is large.

Once complete you should see a box stating you're all done.

restore complete

How to restore your databases

Restoring your database is even easier than restoring your website's files.

Click the MySQL Databases icon.

mssql

Next, click the 'Restore backup' button.

Restore Mysql Backup

From the drop down list, select the database you want to restore. Make sure you choose the right database or you may overwrite the wrong one.

select mysql database

Click the choose file button and select the database you want to restore and finally click the 'restore' button.

Choose mysql then restore

If everything has gone correctly, you should get a database restored message.

Restore complete Mysql

Your database is now restored.



Leave a comment

Has this guide helped you? Have an idea for a guide or need help? Let us know below.

© Copyright 2014 | Squirrel Hosting Limited
Company Number 9031308