double posts, disappearing posts, wait times, slow downs and other events that are grieving us are due to a damaged database. Our web hosting company are just very slow at reacting to my mails. I've been working on it for the last 3 days and the result of my efforts is the eventual restoration of the broken bit. Once it has been repaired, things will resume to its normal speed.
For those of you who like to see technical details, read on.
I submitted the following email to the web host. The salient bit is in red:
Basically, a table is broken.
Cheers
For those of you who like to see technical details, read on.
I submitted the following email to the web host. The salient bit is in red:
[Updated: February 2, 2005, 3:08 pm by multiverse at 208.54.14.33]
When I run this:
mysqldump -p -u multiverse multiverse > multiverse.feb.sql
I get this:
mysqldump: Got error: 1030: Got error 127 from table handler when retrieving data from server
When I run this:
mysqldump -p -u multiverse --opt multiverse > multiverse.feb.sql
I get this:
mysqldump: Got error: 1016: Can't open file: 'nuke_session.MYI'. (errno: 145) when using LOCK TABLES
The Solution:
1) check table tablename to confirm corruptedness
2) repair table tablename;
Relevant Thread:
http://www.devnetwork.net/forums/vie...b688c0aaec9962
Relevant Google Thread:
http://www.google.com/search?sourcei...from+server%22
Many Thanks.
When I run this:
mysqldump -p -u multiverse multiverse > multiverse.feb.sql
I get this:
mysqldump: Got error: 1030: Got error 127 from table handler when retrieving data from server
When I run this:
mysqldump -p -u multiverse --opt multiverse > multiverse.feb.sql
I get this:
mysqldump: Got error: 1016: Can't open file: 'nuke_session.MYI'. (errno: 145) when using LOCK TABLES
The Solution:
1) check table tablename to confirm corruptedness
2) repair table tablename;
Relevant Thread:
http://www.devnetwork.net/forums/vie...b688c0aaec9962
Relevant Google Thread:
http://www.google.com/search?sourcei...from+server%22
Many Thanks.
Cheers
Comment