Bug #59904 MyISAM data is lost after incremental backup

• Submitted: 2 Feb 2011 21:29
• Modified: 4 Feb 2011 8:50
• Reporter: Hema Sridharan
• Status: Closed
• Category: MySQL Enterprise Backup
• Severity: S2 (Serious)
• Version: MEB 3.6
• OS: Linux
• Assigned to: Thava Alagu
• CPU Architecture: Any

[2 Feb 2011 21:29] Hema Sridharan

Description:
- Create database db1 and innodb(t0), myisam(t1) tables.
- Insert data in both the tables. Lets say I insert data 1, 2 in t1
- Perform full backup
- Add some more data to both innodb and myisam table. Lets say I insert data 3,4 in t1
- Perform incremental backup
- Stop server, apply log for full backup, copy-backup, restart the server
- Check the data. Table t1 should have 1,2 
- Again stop server and perform restore for incremental backup, restart the server
- Check the data. Table t1 should have 1,2,3 &4

Table t1 will have only data 1 and 2. 3,4 is missing for MyISAM tables after incremental backup.
NOTE: I executed the test with MEB 3.6 version from bzrroot/meb/sbin-repo/single-bin/ repo in mysql-5.1-meb server.

How to repeat:
Please find the attached test case to reproduce the bug.

[2 Feb 2011 21:30] Hema Sridharan

Please find the attached test case

Attachment: incremental_bug.test (application/octet-stream, text), 2.40 KiB.