39718: MassTransit Database Backup Procedures for Windows

Translate to:

Applies to:

Operating Systems:

Summary:

This article describes how to configure and use the MySQL Administrator* application in order to automate the backup of MassTransit HP, Professional, Enterprise, Premier and Standard server databases.

Description:

The MySQL Administrator application is used to control and configure many aspects of the databases that MassTransit uses for file transfer operations. One of the more powerful and often overlooked features of the administrator is the ability to schedule automated backups of the MassTransit databases. At a specified interval, the Administrator will make complete copies of the MassTransit data, creating a .sql file containing all database contents. In the event that database recovery is necessary, the contents of this .sql file may be imported through a simple restoration process via the same Administrator tool.

Database Backup Process:

  1. Launch the MySQL Administrator tool.
  2. A dialog box will appear, prompting you to enter the Server Host, Username, and password.
    • Server Host is usually localhost, or the IP address of the server that is running both MySQL Server and MassTransit Server.
    • The username and password fields should be populated with the MassTransit MySQL user information that was specified at initial installation time.
  3. Once the MySQL Administrator tool has launched, click on the Backup option which appears in the left-hand window pane.
  4. In the right-hand window pane, three tabs should appear: Backup Project, Advanced Options, and Schedule.
  5. Make sure that the Backup Project tab is selected, and then click the New Project button located towards the bottom of the Administrator window.
  6. Once the MySQL Administrator tool has launched, click on the Backup option which appears in the left-hand window pane.
  7. Next, provide the Project Name field with a name for the MassTransit Database backup project. For example, MT_Backup.
  8. Then, under the Schemata column, select mtdatabase, which is your MassTransit data schema, followed by the > button.
  9. The mtdatabase schema should now appear to the left, within the Backup Content window.
  10. Next, select the Advanced Options tab, appearing in the right window pane.
  11. Select the Lock all tables option if it is not already selected.
  12. In order to make a backup of all tables, make sure that the Complete backup option is also selected.
  13. Within the Output File Options window, make sure that SQL Files is selected in the Backup Type pulldown menu.
  14. Select the Save Project button to retain the changes made to your new backup project.
  15. After successful configuration, the backup project that you have just created should appear under the Backup Projects column, in the left window pane.
  16. Click the Execute Backup Now button.
  17. Select a directory in which your backup .SQL files are stored. NOTE: It is highly recommended that the location specified here be a drive or volume other than the volume that which contains your “live” MySQL data and MassTransit installation. This is to insure that backup data is not lost in the event of storage hardware failure.

* If you don't have the MySQL Administrator you can do a backup following these directions - Backup Databases.

Database Restoration Process:

  1. Launch the MySQL Administrator tool.
  2. A dialog box will appear, prompting you to enter the Server Host, Username, and password.
    • Server Host is usually localhost, or the IP address of the server that is running both MySQL Server and MassTransit Server.
    • The username and password fields should be populated with the MassTransit MySQL user information that was specified at initial installation time.
  3. Once the MySQL Administrator tool has launched, click on the Restore option which appears in the left-hand window pane.
  4. Click the Open Backup File button and select a backup file.
  5. Check the Create databases if they don't exist setting checkbox.
  6. Make sure that utf8 is set in the Character Set section.
  7. Select the Restore Content tab and click on the Analyze Backup File Content button.
  8. Expand the selection to make sure all of the tables are selected.
  9. Click on the Start Restore button.

* If you don't have the MySQL Administrator you can do a restoration following these directions - Restore Databases.

Tags: 

You are reporting a typo in the following text:
Simply click the "Send typo report" button to complete the report. You can also include a comment.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
6 + 14 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.