MySQL Bugs: #36380: Backup does not correctly backup merge tables

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:	None
Category:	MySQL Server: Backup	Severity:	S3 (Non-critical)
Version:	6.0.5	OS:	Any
Assigned to:	Chuck Bell	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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.

This bug report was solved with the patch for WL#3572.