Repair broken innodb on a cPanel Server

To repair corrupted/broken Innodb on cPanel servers, follow the bellow given steps:

Stop mysqld:

   /etc/init.d/mysql stop
Backup /var/lib/mysql/ib*

   cp -apr /var/lib/mysql/ib* /root/innodb_back/
 
Add the following line into /etc/my.cnf:
 
   innodb_force_recovery = 4

Restart mysqld:

   /etc/init.d/mysql restart

Dump all tables:

   mysqldump -A > dump.sql

Drop all databases which need recovery

Stop mysqld:

   /etc/init.d/mysql stop

Remove /var/lib/mysql/ib*

   rm -rf /var/lib/mysql/ib*
 
Comment out innodb_force_recovery in /etc/my.cnf:

   #innodb_force_recovery = 4

Restart mysqld:

   /etc/init.d/mysql restart

Restore databases from the dump:

   mysql < dump.sql

--