Loading...

MySQL Restore (General)

Use this dialog box to control how the specified data is to be restored.

Note that restore options vary for single and multiple database restore jobs. The differences are noted below:

Destination Server

Displays the name of the instance to which the selected data will be restored. To change the destination, click one from the list.

Source Server

Displays the name of the source server or database, depending on whether an instance or database was selected for restore.

Destination Server State

Displays the current state of the server.

Refresh

Click to update the current state of the server.

Database List

Lists the database for which you select the objects to restore.

Options

Specifies the restore options.

  • Data

    When selected, specifies that it will allow Data only restores. You will be able to get only database dump files of any FULL job.

  • Log

    When selected, specifies that it will allow Log only restores. You will be able to recover any logs from any backup job.

  • Recurring Restore

    When selected, allows you to replicate data from one server to another to be used in Fail over cases.

  • Restore all database objects

    This option appears for table-level restores. When selected, this option allows you to include triggers, views, and user-defined functions in the restore.

  • Drop objects if exist

    This option appears for table-level restores. When selected, this option allows you to delete tables from the source database prior to restore.

  • Define auxiliary database name for Table Restores

    This option appears for table-level restores. When selected, this option allows you to import selected tables to a different database other than the specified database.

    • Source Database

      Displays the name of the source database, depending on the database selected for restore.

    • Target Database

      Displays the path to the database that is used to restore the selected tables from the source database. Click and specify the path to change the target database.

  • Recover

    Specifies that the restore operation must recover the database.

    • Staging Location

      You can restore the latest copy of the transaction logs from a production server to a standby server. If the database on your production server fails, you can apply the latest log backup to the standby server and bring it online.

    • Browse

      Click to specify the path of the Destination Folder to store the data and logs.

  • Do Not Recover

    Specifies that the database will not be recovered.

    • Destination Folder

      Specifies the path of the Destination Folder to store the logs without applying to the server.

    • Browse

      Click to specify the path of the Destination Folder to store the logs.

Point in time

Specifies that the restore operation must restore single or multiple databases to the selected date and time.

Restore Time and Time Zone

Displays only those jobs that occurred within the specified point in time. Select the following options:
  • Restore Time

    Provides a space for you to enter the date and time. Click the arrow to display a calendar.

  • Time Zone

    Lists the time zones. To change the time zone, select one from the list.

Advanced

Click to select additional restore options.

Save As Script

Click to open the Save As Script dialog, which allows you to save this operation and the selected options as a script file (in XML format). The script can later be executed from the Command Line Interface using qoperation execute command.

When you save an operation as a script, each option in the dialog will have a corresponding XML parameter in the script file. When executing the script, you can modify the value for any of these XML parameters as per need.

For more information on restores performed from the command line, see Command Line Interface for MySQL iDataAgent.