When running a repair on the database through the admin interface it kept failing on the large "post" table. I tried to repair the post table separately through phpMYadmin and it failed again. Each time it would kick up a bunch of apache processes that would cause high loads and freeze up the server.
I tried to repair the table through command line using the myisamchk repair option and it failed again, saying that /tmp was full. I tried adding tmpdir = /home/mysqltemp to my.conf and restarted mysqld and it still failed on /tmp, saying its full.
That left the option of manually increasing /tmp, moving the database to another server and repairing it, or going back to the 5 a.m. backup. Since each repair attempt took so long I decided to revert back to the 5 a.m. backup.
I was cautious about the 5 a.m. backup because it took place right around the same time the issue came up. But it looks like it took.
I want to move from vBulletin to Invision Power Board. I like that it has a feature where you can rate each post rather than just give reputation.
I purchased the Invision suite (CMS, chat, forum), dating software (datemill), and member management software (amember). I've been prepping a new server to get it all installed.
