Bug #36380 Backup does not correctly backup merge tables
Submitted: 28 Apr 2008 15:27 Modified: 14 May 2008 16:53
Reporter: Chuck Bell Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server: Backup Severity:S3 (Non-critical)
Version:6.0.5 OS:Any
Assigned to: Chuck Bell CPU Architecture:Any

[28 Apr 2008 15:27] Chuck Bell
The backup system incorrectly includes merge tables in the backup process. For example, if there are three tables, m1-m3 and a merge table m4 when backup is run, it reads the data from m1-m3 plus data from m4 resulting in duplicate data in the backup stream.

Worse, on restore if the merged tables are included first, there are errors when the merge table is repopulated.

How to repeat:
Create myisam tables plus merge table in same database and backup then restore.

Suggested fix:
Make backup system detect merge tables as no data engines. WL#3572 will solve this bug.
[14 May 2008 16:53] Chuck Bell
This bug report was solved with the patch for WL#3572.