Bug #28559 Unable to restore database from backup
Submitted: 21 May 2007 12:39 Modified: 21 May 2007 14:47
Reporter: Lim tienaik Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S2 (Serious)
Version:5.1.16-beta-community-nt OS:Windows
Assigned to: CPU Architecture:Any
Tags: corruption, myisam, restore

[21 May 2007 12:39] Lim tienaik 
Description:
i had a backup file which consist of 2 tables, the size of those 2 tables are 16gb. When i tried to run restore on the generated backup.sql it gives error

H:\data>mysql -u root -p bitest < backup200705160910.sql
Enter password: *******
ERROR 126 (HY000) at line 44226583: Incorrect key file for table '.\bitest\hq_pos_sales.MYI'; try to repair it

How to repeat:
run the large dump file
[21 May 2007 12:42] Lim tienaik 
Error message in the err file

070521  2:36:01 [ERROR] H:\mysql5.1\bin\mysqld-nt: Incorrect key file for table '.\bitest\hq_pos_sales.MYI'; try to repair it
070521  8:17:32 [ERROR] H:\mysql5.1\bin\mysqld-nt: Table './bitest/hq_pos_sales' is marked as crashed and should be repaired
070521  8:17:32 [ERROR] H:\mysql5.1\bin\mysqld-nt: Table './bitest/hq_pos_sales' is marked as crashed and should be repaired
070521  8:57:03 [ERROR] H:\mysql5.1\bin\mysqld-nt: Incorrect key file for table '.\bitest\hq_pos_sales.MYI'; try to repair it
070521 20:30:36 [ERROR] H:\mysql5.1\bin\mysqld-nt: Table './bitest/hq_pos_sales' is marked as crashed and should be repaired
[21 May 2007 13:13] Valeriy Kravchuk 
Thank you for a problem report. Are you sure you have enough free disk space? Please, send your my.ini file content, for the beginning.
[21 May 2007 14:04] Lim tienaik 
the my.ini file

Attachment: my.ini (application/octet-stream, text), 9.30 KiB.
[21 May 2007 14:05] Lim tienaik 
should hav enough diskspace

Attachment: freespace.jpg (image/pjpeg, text), 17.68 KiB.
[21 May 2007 14:22] MySQL Verification Team 
I guess this is most likely related to bug #24566
Please check the file size of the tables .MYI, .MYD after you receive the error. Is it about 2GB in size?
[21 May 2007 14:42] Lim tienaik 
that does rings a bell...

H:\mysql5.1\data\bitest>dir
 Volume in drive H has no label.
 Volume Serial Number is E843-CB69

 Directory of H:\mysql5.1\data\bitest

05/21/2007  08:18 AM    <DIR>          .
05/21/2007  08:18 AM    <DIR>          ..
05/21/2007  01:41 AM                65 db.opt
05/21/2007  08:18 AM             9,248 hq_pos_sales.frm
05/21/2007  09:04 AM     2,147,489,040 hq_pos_sales.MYD
05/21/2007  09:04 AM             1,024 hq_pos_sales.MYI
               4 File(s)  2,147,499,377 bytes
               2 Dir(s)  94,411,624,448 bytes free
[21 May 2007 14:47] MySQL Verification Team 
Lim, please try 5.1.18 which should work better.  This bug is probably a duplicate of #24566

Get it here: http://dev.mysql.com/downloads/mysql/5.1.html#win32