iWeb Posted April 7, 2012 Share Posted April 7, 2012 I just used myisamchk -r --force --fast /var/lib/mysql/ipb/posts.* as an attempt to fix a crash table. It was running really fast, but now it's stuck at "index 8" and has not moved for an hour. Is this normal? Data records: 2400361 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 - Fixing index 5 - Fixing index 6 - Fixing index 7 - Fixing index 8 2400000 Link to comment Share on other sites More sharing options...
iWeb Posted April 7, 2012 Author Share Posted April 7, 2012 It's now completed, but gives me an error: myisamchk: error: File '/var/lib/mysql/ipb/posts.TMD' doesn't exist What can I do to correct this? Link to comment Share on other sites More sharing options...
PeterUK Posted April 8, 2012 Share Posted April 8, 2012 You should check and see if your /tmp directory is getting full (the partition it's on) as that's where the files are normally stored as they are rebuilt. Sometimes they can be stored inside your database directory though (in your case, /var/lib/mysql/ipb/). I would normally issue this command:mysaimchk --force --fast --update-state /var/lib/mysql/ipb/*.MYI Depending on the speed of your server, and size of your forum, yes it can be normal to be stuck at an index rebuild for some time. The .TMD file is the temporary/intermediate file that's generated while myisamchk is repairing your tables. Also, make sure the MySQL server is completely offline while you issue these commands. If you're still having issues with this, then launch the MySQL server and run this:mysqlcheck -u root -p --auto-repair --check --optimize --all-databases This will repair and optimise all databases and all tables within them, and is another method to try and repair the table. Be warned that little progress will be shown while this happens and it may take quite some time. If you're familar with it, I would suggest using screen on Linux in case you get disconnected during. Link to comment Share on other sites More sharing options...
iWeb Posted April 8, 2012 Author Share Posted April 8, 2012 Thanks Peter it's fixed now. :) Link to comment Share on other sites More sharing options...
PeterUK Posted April 8, 2012 Share Posted April 8, 2012 Thanks Peter it's fixed now. :) Can I ask which command fixed it? Just out of curiosity. :P Link to comment Share on other sites More sharing options...
iWeb Posted April 13, 2012 Author Share Posted April 13, 2012 Can I ask which command fixed it? Just out of curiosity. :tongue:mysaimchk --force --fast --update-state /var/lib/mysql/ipb/*.MYI Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.