Logaul Posted July 25, 2008 Share Posted July 25, 2008 Does anybody know how to fix this error? There wasn't any problems with it before, at all, and then one day I woke up to an error saying MySQL crashed and needed to close or something. Happened again and again. Decided to look at when it was happening, and it was whenever my automatic backup ran, so I tried running it manually and here's the result C:\Documents and Settings\Administrator>C:\MySQL\bin\mysqldump.exe --skip-opt -B --compact --skip-comments -t -q -n --add-locks --flush-logs --lock-all-tables - e -l --skip-add-drop-table -u root -pPASSWORD database>C:\\backup.sql mysqldump: Error 1030: Got error -1 from storage engine when dumping table `logs` a t row: 2071976 If I drop that table the problem goes away. It's just a normal archive table, used for storing access logs. Why has it suddenly started throwing errors when I try to back it up? Any help would be greatly appreciated Also I'd like to mention again, this has been working fine for over a year. It's only started erroring up recently. Oh and there are no results on Google for "Got error -1 from storage engine when dumping table" so I'm guessing this is the first time this error has occurred? Or was that just the wrong way to search? Quote Link to comment Share on other sites More sharing options...
Logaul Posted July 26, 2008 Author Share Posted July 26, 2008 Bump I really need to be able to make backups again. Hopefully soon. Quote Link to comment Share on other sites More sharing options...
fenway Posted July 26, 2008 Share Posted July 26, 2008 Did you CHECK TABLEs? Quote Link to comment Share on other sites More sharing options...
Logaul Posted July 27, 2008 Author Share Posted July 27, 2008 It says "corrupt". I can't REPAIR TABLE it or anything though. It either crashes the table, or returns error "Unknown - internal error 144 during operation" and doesn't do anything. If it crashes the table I have to shut down the whole server and repair it with myisamchk.exe, which uncrashes the table (but check table still says it's corrupted, and I still have problems backing it up). Any ideas? Quote Link to comment Share on other sites More sharing options...
Logaul Posted July 27, 2008 Author Share Posted July 27, 2008 BTW this it what it looks like when it's crashes Not sure if any of that's useful for not. I know I don't understand any of it, lol. Quote Link to comment Share on other sites More sharing options...
fenway Posted July 28, 2008 Share Posted July 28, 2008 It says "corrupt". I can't REPAIR TABLE it or anything though. It either crashes the table, or returns error "Unknown - internal error 144 during operation" and doesn't do anything. If it crashes the table I have to shut down the whole server and repair it with myisamchk.exe, which uncrashes the table (but check table still says it's corrupted, and I still have problems backing it up). Any ideas? REPAIR comes in all different flavours... which one are you running? Do you have a recent backup/ Quote Link to comment Share on other sites More sharing options...
Logaul Posted July 28, 2008 Author Share Posted July 28, 2008 "repair table database.table" crashes it Trying to back it up sometimes crashes it "myisamchk.exe -A -o -p /MySQL/data/database/table.MYI" while mysql is turned fixes it from being crashed Since I can't reliably use the mysql functions for backing it up, I'm making my backups by manually copy/pasting the data folder for now. If that works, then yes. I can make another one right this second if you want. Then what? Quote Link to comment Share on other sites More sharing options...
Logaul Posted July 29, 2008 Author Share Posted July 29, 2008 Sorry for bumping this again but it's kind of important Quote Link to comment Share on other sites More sharing options...
Logaul Posted July 31, 2008 Author Share Posted July 31, 2008 Is it that I have to buy the enterprise version to be allowed to back up tables over a certain size? If so, any ideas how to crack it? Please help! Quote Link to comment Share on other sites More sharing options...
Logaul Posted July 31, 2008 Author Share Posted July 31, 2008 bump Quote Link to comment Share on other sites More sharing options...
fenway Posted July 31, 2008 Share Posted July 31, 2008 You have to repair this table before you back it up -- there's no other choice. Quote Link to comment Share on other sites More sharing options...
Logaul Posted August 4, 2008 Author Share Posted August 4, 2008 "repair table database.table" crashes it "myisamchk.exe -A -o -p /MySQL/data/database/table.MYI" while mysql is turned off fixes it from being crashed Any ideas? Quote Link to comment Share on other sites More sharing options...
Logaul Posted August 5, 2008 Author Share Posted August 5, 2008 P.S. select * from table also kills mysql. PLEASE will somebody try to help? It's very bad not being able to back up my database! Quote Link to comment Share on other sites More sharing options...
Logaul Posted August 5, 2008 Author Share Posted August 5, 2008 Actually nevermind f*** it I give up. I can't figure this out on my own and none of you want me to help me so... 2 years of records gone. Guess it's time to give postgreSQL a try... hopefully it will be more reliable. Quote Link to comment Share on other sites More sharing options...
fenway Posted August 6, 2008 Share Posted August 6, 2008 Actually nevermind f*** it I give up. I can't figure this out on my own and none of you want me to help me so... 2 years of records gone. Guess it's time to give postgreSQL a try... hopefully it will be more reliable. Listen buddy, watch the language... I told you before, you have to figure out why your table is corrupt. It's that simple -- and if you can't REPAIR it (and there are 5 version of REPAIR), you can have to restore it from backup. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.