pioneerx01 Posted March 2, 2012 Share Posted March 2, 2012 Hi, I have this problem with one of my tables: "#1034 - Incorrect key file for table 'system'; try to repair it" I tried doing "repair table 'system'" but it still gives me the error. I tried to recover from SQL backups but no luck. I have contacted the host provider and they could not do anything. Thus i ma reaching out to people here, that are probably smarter than the provider, to see if anyone has any way of getting the data from the table back. I am new (1-year) to MySQL so please speak "slowly" thanks Link to comment https://forums.phpfreaks.com/topic/258142-1034-incorrect-key-file-for-table-corrupt-table/ Share on other sites More sharing options...
mikosiko Posted March 2, 2012 Share Posted March 2, 2012 Mysql version? storage engine for the table? (Myisam , Innodb...) , table description (full create table)? a quick google search shows severals answers... from reported bugs (could be old) to some workarounds depending on conditions... examples: http://www.progtalk.com/viewarticle.aspx?articleid=2281 http://bugs.mysql.com/bug.php?id=5686 // around the end of the multiples posts is one possible workaround good search Link to comment https://forums.phpfreaks.com/topic/258142-1034-incorrect-key-file-for-table-corrupt-table/#findComment-1323314 Share on other sites More sharing options...
pioneerx01 Posted March 3, 2012 Author Share Posted March 3, 2012 Yes, I was Google-ing this for two days. I did not find much to help me, including some softwares. MySQL 5.1.56 with MyISAM storage engine. I ma not sure what you mean by table description. Link to comment https://forums.phpfreaks.com/topic/258142-1034-incorrect-key-file-for-table-corrupt-table/#findComment-1323336 Share on other sites More sharing options...
mikosiko Posted March 3, 2012 Share Posted March 3, 2012 table description.. or definition or structure or whatever you want to call it... that sentence starting with... CREATE TABLE <table_name> etc...etc...tc... Link to comment https://forums.phpfreaks.com/topic/258142-1034-incorrect-key-file-for-table-corrupt-table/#findComment-1323405 Share on other sites More sharing options...
pioneerx01 Posted March 3, 2012 Author Share Posted March 3, 2012 Oh, I have no idea. I was not the one who created the table, but I am the one stuck with the problem... Link to comment https://forums.phpfreaks.com/topic/258142-1034-incorrect-key-file-for-table-corrupt-table/#findComment-1323406 Share on other sites More sharing options...
mikosiko Posted March 3, 2012 Share Posted March 3, 2012 http://dev.mysql.com/doc/refman/5.0/en/show-create-table.html Link to comment https://forums.phpfreaks.com/topic/258142-1034-incorrect-key-file-for-table-corrupt-table/#findComment-1323411 Share on other sites More sharing options...
pioneerx01 Posted March 3, 2012 Author Share Posted March 3, 2012 I can not run that successfully. I it still gives me "#1034 - Incorrect key file for table 'system'; try to repair it" when I try to run it Link to comment https://forums.phpfreaks.com/topic/258142-1034-incorrect-key-file-for-table-corrupt-table/#findComment-1323412 Share on other sites More sharing options...
mikosiko Posted March 3, 2012 Share Posted March 3, 2012 did you try to run myisamchk over the table?... results?... what else have you tried? this could be helpful http://www.techrepublic.com/article/checking-and-repairing-mysql-tables/5193721 Link to comment https://forums.phpfreaks.com/topic/258142-1034-incorrect-key-file-for-table-corrupt-table/#findComment-1323417 Share on other sites More sharing options...
pioneerx01 Posted March 3, 2012 Author Share Posted March 3, 2012 This is where speak slowly comes in. I am trying to run "myisamchk --safe-recover system.MYI" but it gives me "#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'myisamchk --safe-recover system.MYI' at line 1" Link to comment https://forums.phpfreaks.com/topic/258142-1034-incorrect-key-file-for-table-corrupt-table/#findComment-1323425 Share on other sites More sharing options...
Pikachu2000 Posted March 3, 2012 Share Posted March 3, 2012 myisamchk is a command line tool. Link to comment https://forums.phpfreaks.com/topic/258142-1034-incorrect-key-file-for-table-corrupt-table/#findComment-1323432 Share on other sites More sharing options...
fenway Posted March 5, 2012 Share Posted March 5, 2012 Just delete the MYI file and repair the able. Link to comment https://forums.phpfreaks.com/topic/258142-1034-incorrect-key-file-for-table-corrupt-table/#findComment-1323985 Share on other sites More sharing options...
alva Posted December 4, 2013 Share Posted December 4, 2013 I encountered the same problem with MySQL table that lead top data corruption. I store my important data in MySQL database and when it becomes inaccessible I was annoyed. But all thanks to my friend she advised me to use MySQL Repair Tool and this repair tool helped me alot. Link to comment https://forums.phpfreaks.com/topic/258142-1034-incorrect-key-file-for-table-corrupt-table/#findComment-1461183 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.