Error Code [87:19] Restore Failed with MySql Error

Article ID: MSQL0001 A restore operation for MySQL from the same host or to a different host fails with error Error Code 87:19: Restore Failed with MySQL Error

Symptom

A restore operation of MySQL databases or tables to the same host or to a different host fails with the following error:

Error Code: [87:19]
Description: MySQL Database: [~mydataabase1~] Restore Failed with MySql Error: [~Failed to import. MYSQL Error -- ERROR 1050 (42S01) at line 19: Table 'mydataabase1_table1' already exists mysqldump: Got errno 32 on write ~].

Cause

You are trying to restore databases or tables that already exist on the MySQL server. By restoring the databases or tables, you are duplicating them on the server. This causes the restore operation to fail.

Resolution

You must drop the existing databases or tables for the restore option to complete.

  1. From the CommCell Browser, expand Client Computers > Client > MySQL > Instance.
  2. Right-click the subclient, and then select Browse and Restore.
  3. On the Browse and Restore options window, identify the data that you want to restore.
  4. Select Table View and click View Content.
  5. From the Browse window, select the tables to restore.
  6. Click Recover All Selected. The MySql Restore dialog box is displayed.
  7. From the Destination Server list, select the name of the destination client where you want to restore the tables.
  8. To delete the existing databases or tables before the restore, under Options, select the Drop Database or Table if exists check box.
  9. Select Point-in-time, and then set the restore date, time, and time zone to the appropriate values.
  10. Click OK.

For more information, see Restoring MySQL Tables to the Same Host and Restoring MySQL Tables to a Different Host.