compared with
Current by Nathan McCoy
on Jun 23, 2016 10:20.

Key
This line was removed.
This word was removed. This word was added.
This line was added.

Changes (12)

View Page History
h3. Problem
{kb-symptom} ----
When some users upgraded to Server Backup Manager version 5.14.3 build 428, they could not view databases for old Disk Safe recovery points. The data was not lost; it was a simple mapping issue. With this in mind, R1Soft has released the MySQL Repair tool, which will restore the mapping and update the new metadata.

For the tool to work, you will need a Disk Safe containing the original 'metadata' folder as well as the new 'metadata2' folder. When the tool has been installed and completed, users will be able to reopen the recovery point screen and browse databases for old recovery points.

h3. Solution
{kb-resolution} ----
To install the MySQL Repair tool, access [http://repo.r1soft.com/contrib/] and download the *MySQLRepair.tgz* file. Extract the file using the following command:
* *tar \-xvzf MySQLRepair.tgz*

bq. *tar \-xvzf MySQLRepair.tgz*

{note}
To prevent further issues, *the target Disk Safe should be closed* before the MySQL Repair tool runs.
{note}

Access the _MySQLRepair_ directory and execute the following command:
* *./fixit \-dsPath $PATH_TO_DS* (where "$PATH_TO_DS" represents the folder that contains the 'metadata' and 'metadata2' folders)

* For example
bq. *./fixit \-dsPath $PATH_TO_DS*

{info:title=Note}
In the previous command, "$PATH_TO_DS" represents the folder that contains the 'metadata' and 'metadata2' folders, i.e. _./fixit \-dsPath /Volume/MySQL/fd123336-a4e5-2345-6789-1abc2c345dde_
{info}

The message "Update complete" displays when the tool is finished running. To verify that the MySQL Repair tool installed properly, login to SBM, open the Disk Safe, browse recovery points and verify that the "Browse Databases" icon is enabled. Then, perform a restore of any MySQL database.

h3. Considerations

* Remember to close the Disk Safe to be fixed before running the MySQL Repair tool.
* New recovery points created after upgrading to version 5.14.3 build 430 will not be affected by the use of this tool.
* The fix can be applied in 5.14.3 build 428 or build 430.
* This tool is solely for the use case where the Disk Safe can be accessed after a successful conversion, but the customer cannot view databases for recovery points created before the upgrade. This tool cannot be used on a Disk Safe that has not been converted.