About the New MySQL for Webserve data backup and restoration policy

On this page:


Data backup process specifics

The New MySQL for Webserve service features a new robust data backup service intended for use in server-wide service outages. The server utilizes the MySQL Enterprise backup features to maintain backups on the following schedule:

  • Full backups are created on Mondays and Thursdays.
  • Incremental backups are created maintained on all other days.
  • All backup processes take place at 1:02am.

These backups are retained for 14 days for service-wide disaster recovery purposes.

Site data restoration policy

If you need to back up or restore your data for any purpose (development, transference from production to test, etc.), you should take advantage of the functionality and tools that MySQL Workbench offers (e.g., mysqldump or Data Export and Import Wizard).

The Database Administration team will perform MySQL data restoration in extremely limited cases, such as data loss due to SQL injection or unforeseen corruption. Data restoration services are performed on a case-by-case basis and are subject to review and approval by administrators. In all cases, data restoration is limited to the previous night's updates. Binary logs are not active, and it is not possible to provide point-in-time recovery. Data restoration may take up to 48 business hours to process.

To request data restoration, contact the Web Services Support team. Include the date and time the incident requiring data recovery occurred and the type of incident that spurred your request. You may be asked to provide information about what steps you have taken to mitigate the need for future data restoration. Web Services Support will forward your request to the Database Administration team, who will contact you with options or further questions they may have.

Departments and owners of sites who require 24x7 data backup and restoration services are encouraged to contact the Database Administration team to discuss options, which may include creating an Enterprise MySQL instance for just that site's content and on-call data recovery services. A fee may be associated with these services.

Manually back up your New MySQL for Webserve schemas

Create a backup using MySQL Workbench

Note:
Store this backup file in a manner consistent with the data classification appropriate to your site's content. Sites which store sensitive internal or critical data must be stored in secure locations.
  1. Connect to your MySQL database.
  2. Click Server on the main tool bar.
  3. Select Data Export.
  4. Select the tables you want to back up.
  5. Under Export Options, select where you want your dump saved. By default, it will save to your Documents folder in a subfolder titled dumps.
  6. Click Start Export.
    Note:
    You may get a message about a mismatch between your mysqldump.exe version and the MySQL Server version. You can update your local MySQL version or continue.
  7. You now have a backup version of your site. Store this content securely in a manner consistent with your MySQL schema content's data classification.

Load a MySQL dump from MySQL Workbench

To load a MySQL dump file after a database failure or corruption:

  1. Connect to your MySQL database.
  2. Click Server on the main tool bar.
  3. Select Data Import.
  4. You should see a link to the default dump folder, typically your Documents folder in a subfolder titled dumps.
  5. Click the ... and navigate to where your MySQL backup file is located, select the backup you want to load, and click OK.
  6. The schema names in your dump should appear on the left-hand side, at the bottom. Select the schemas that need to be restored.
  7. Select Start Import on the bottom right.

This is document apnn in the Knowledge Base.
Last modified on 2018-02-15 08:07:56.

  • Fill out this form to submit your issue to the UITS Support Center.
  • Please note that you must be affiliated with Indiana University to receive support.
  • All fields are required.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.

  • Fill out this form to submit your comment to the IU Knowledge Base.
  • If you are affiliated with Indiana University and need help with a computing problem, please use the I need help with a computing problem section above, or contact your campus Support Center.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.