I'm running CentOS6.3 and the only way to get MySQL to start is to add the following line to /etc/my.conf:

innodb_force_recovery = 3

I ran mysqlcheck -u root -p --auto-repair --check --optimize social

and it comes back with several tables that basically say something like:

social.phpfox_feed
Warning : InnoDB: Index 'privacy_3' contains 41031 entries, should be 41030.
Warning : InnoDB: Index 'privacy_4' contains 41031 entries, should be 41030.
Warning : InnoDB: Index 'type_id' contains 41031 entries, should be 41030.
Warning : InnoDB: Index 'privacy' contains 41031 entries, should be 41030.
Warning : InnoDB: Index 'time_stamp' contains 41031 entries, should be 41030.
Warning : InnoDB: Index 'time_update' contains 41031 entries, should be 41030.
Warning : InnoDB: Index 'privacy_6' contains 41031 entries, should be 41030.
error : Corrupt

I am at a loss. I don't know what commands to run or what to do to fix this and with innodb_force_recovery = 3 in my.conf file I cannot do any writes to the db.

I downloaded the entire /var/bin/mysql folder and files and I was also able to use phpmyadmin to download a backup of the database but I cannot get mysql to run without innodb_force_recovery = 3

I was going to drop the db and then import the downloaded copy to see if if would import but I cannot do anything with innodb_force_recovery = 3 turned on.