Note: Please go to docs.rightscale.com to access the current RightScale documentation set. Also, feel free to Chat with us!
Home > ServerTemplates > Archive > Pre-11H1 > MySQL-S3 > Database Manager for MySQL-S3 Runbook > MySQL-S3 Recipes > Restore a previous DB backup

Restore a previous DB backup

By default, the most recent backup file in the backups directory will be used to restore the database.   You can also manually restore a particular file with a few extra steps, which are highlighted with **

For security purposes, you are not allowed to restore a backup onto a DB instance that already contains a database. Therefore, make sure to have an empty DB or to manually drop any existing databases from the instance before performing the "DB master restore" operational action. The time required to perform a restoration of the database will vary depending on its size.

Instructions

  1. Access the page of the running DB instance on which to restore the backup:
     - Go to the running slave DB's instance page.  (Manage -> Servers)
     - Locate and click on the nickname of the instance where you would like to perform a DB restore.
  2. Temporarily change the file prefix input **only if you are restoring from a specific file**:
     - click on the "edit" link next to operational inputs.
     - Write down the current value for BACKUPFILE_PREFIX because later on you will change the filename back to this filename.
     - Modify the value to have a more complete prefix, so that it matches all of the digits of the file that you want to restore. For example, you might have to change the value from "mypath/mybackup" to "mypath/mybackup-200709081189"
     - Save the changes.
  3. Click on the "DB master restore" operational action.
  4. Wait until the action is successfully completed.
  5. Change the file prefix back to the original value  **only if you are restoring from a specific file** :
     - click on the "edit" link next to operational inputs.
     - Modify the BACKUPFILE_PREFIX value to the original one (the value written down in step 2 above).
     - Save the changes.

What feedback to expect

After clicking on the "DB master restore" action, the Recent Events pane will highlight the progress of the operation.  Once the DB is successfully restored, we should be able to verify that the new data from the restored file is being served.  You might want to point the application to it and inspect the results in some pages, or manually connect to the instance and execute some SQL queries to verify that some data exists.

 

 

You must to post a comment.
Last modified
21:35, 16 May 2013

Tags

This page has no custom tags.

Classifications

This page has no classifications.

Announcements

None


© 2006-2014 RightScale, Inc. All rights reserved.
RightScale is a registered trademark of RightScale, Inc. All other products and services may be trademarks or servicemarks of their respective owners.