Last updated on: 2018-10-24
Authored by: Rackspace Support
Cloud Databases offers multiple ways to back up and restore your database. Backup files are stored in Cloud Files and are subject to standard Cloud Files charges. The files remain in your Cloud Files account until you delete them, except for scheduled backup files, which are automatically deleted based on a set retention period.
This article describes how to create a backup for your database, view details about a backup, and delete or restore a backup. You can also schedule automatic backups of your databases. For more information, see Scheduled backups for Cloud Databases.
To create a backup of a database instance, use the following steps:
Log in to the Cloud Control Panel.
In the top navigation bar, click Select a Product > Rackspace Cloud.
Select Databases > MySQL.
Click the gear icon next to the name of the instance that you want to back up, and select Create Backup.
A dialogue box displays.
Enter a name for the backup and a description, and then click Create Backup.
Note: The backup name is required and cannot exceed 64 characters.
WARNING: The behavior of your instance during a backup depends on the storage engine that you are using for tables. If you use only InnoDB, write access to your database instance is not suspended. If you have MyISAM tables, those databases are write-locked during the backup process.
Things to Consider
In the top navigation bar click Backups > MySQL Backups to view all backups for databases in your account. The following details are displayed:
To view all the backups created for a specific instance, use the following steps:
In the top navigation bar, click Databases > MySQL.
Click the name of the instance for which you want to view backups.
The Instance Details page displays. The number of backup files is displayed next to Backups in the details list.
Click the number of backups and a dialogue box displays with a list of all backups created for that instance.
You can hover over the backup name for additional details or click the gear icon to copy, restore, or delete the backup.
Use the following steps the delete a backup:
Click the gear icon next to the name of the backup that you want to delete and select Delete Backup.
A dialogue box displays, asking for confirmation to delete the backup.
Click Delete Backup.
You can also delete any backups for an instance from the Instance Details page.
To restore a backup to a new instance, use the following steps:
Click the gear icon next to the name of the backup that you want to restore and select Restore.
A dialogue box displays.
Enter a name for the new instance, select the amount of RAM and disk that you want.
The volume size is set by default to the value of the original size of the database before the backup. You must specify a volume greater than that of the original size of the database.
Note: RAM amount and disk size affect the cost of the instance.
Click Create Instance.
All user accounts, credentials, and access permissions that were saved on the instance at the time of the backup are restored along with the databases. Once restored, you can create new users or databases, but they cannot be the same as the ones from the instance that was backed up.
©2020 Rackspace US, Inc.
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License