Bug #37261 Restore database with Myisam/Native drivers fails at times

• Submitted: 7 Jun 2008 3:52
• Modified: 23 Jun 2008 12:11
• Reporter: Hema Sridharan
• Status: Can't repeat
• Category: MySQL Server: Backup
• Severity: S3 (Non-critical)
• Version: mysql-6.0-backup-myisam
• OS: Linux
• Assigned to: Rafal Somla
• CPU Architecture: Any

[7 Jun 2008 3:52] Hema Sridharan

Description:
1) Backup of huge database (more than 5GB).
2) Drop database and perform Restore.
3) Restore fails at times by giving error message as,

mysql> restore from '/data1/backup_dmp/big9';
ERROR 1661 (HY000): o MyISAM restore driver

This error does not occur every time. Also the error message is non-intuitive and shows that there is some problem with Myisam native drivers during Restore.

How to repeat:
Create database db2;
Create table t1(id int, name char(30), pers float(7,2));
create table t2(id int, name char(30), pers decimal(5,2));
Load lots of data in the tables. The size of database after backup was 11GB
Backup database db2 to '/data1/backup_dmp/big9';
Drop Database db2;
Restore from '/data1/backup_dmp/big9';