This website uses cookies We use cookies on this website to provide services, features and to analyze our traffic. You consent to our cookies if you continue to use our website. Accept Cookies Find out more

Backing Up & Restoring MySQL

KB5 Last reviewed 27 November 2013

We strongly advise that all our customers make regular offsite backups of their data including any MySQL databases. Although we do undertake backups, we cannot guarantee their integrity.

Automated Backups

All MySQL databases are automatically backed up every day at 0500 GMT and we typically store upto 7 days of backups for each database. These backups are generally not made available for customer use except in limited circumstances. Please contact our support team if you wish to access an automated backup.

Manual Backup

You may manually backup MySQL databases through the hosting control panel.

To backup a MySQL database, do the following

  1. Log into the hosting control panel
  2. Hover your mouse over the Databases icon and then click on the MySQL 5.x option that will appear to its' right
  3. From the MySQL 5 Databases list, click on the database you wish to manage
  4. Click on the option Maintenance Tools to expand it
  5. Click on the Backup button underneath Maintenance Tools
  6. Select the name of the backup file and where you wish to store the file.
    • You can either download a backup of your database or store it on the server
    • If you opt to save the backup to the server, the size of backup file will be taken into account when measuring your filespace usage.
  7. Click on Backup to start the backup process.
    • If you opted to download the backup, you may be prompted where to save the backup file
  8. Click on Cancel to exit the backup tool.

Manual Restore

You may manually restore MySQL databases through the hosting control panel.

Important: Database backup files can often be quite large in size. If your backup file is larger than 2MB, please upload it to the server using FTP as it may not upload successfully through your web browser.

To restore a MySQL database, do the following

  1. Log into the hosting control panel
  2. Hover your mouse over the Databases icon and then click on the MySQL 5.x option that will appear to its' right
  3. From the MySQL 5 Databases list, click on the database you wish to manage
  4. Click on the option Maintenance Tools to expand it
  5. Click on the Restore button underneath Maintenance Tools
  6. Select the source of the backup file
  7. Click on Restore to start the restoration process.
  8. Once completed, click on Cancel to exit the restore tool.
3
 Loading ...
Copyright © 2011 - 2017 Calzada Media Limited. All Rights Reserved.