Tool for MySQL Data Migration from 5.14.3 build 428

Problem


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.

Solution


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

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

Access the MySQLRepair directory and execute the following command:

./fixit -dsPath $PATH_TO_DS

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

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.

Considerations