hello dear experts, One of our database tables is corrupt and the particular software provider has recommended using mySQL repair database feature? Thks in advance...

If you, by any chance, forgot to create backup, you should do more work as the following: -Edit my.cnf (usually located in /etc/my.cnf) and add this line into [mysqld] section innodb_force_recovery=4 -Restart mysql (e.g: /etc/init.d/mysqld restart)-Your MySQL log should tell you which table is corrupt. You can dump the table using “SELECT … INTO OUTFILE …” from mysql console or using tool like mysqldump Example using MySQL query (you also need to dump the schema later)mysql> SELECT * FROM corrupted_table INTO OUTFILE ‘/path/to/file’ Example using mysqldumproot# mysqldump –opt -u uname -p dbname corrupted_tablename > /path/to/out.sql -Go back to my.cnf and comment the line you wrote from step #1-Go intoMySQL console and drop the corrupted table mysql> DROP TABLE corrupted_tablename; -Import data dump, for sql dump you can use: root# mysql -u uname -p < /path/to/out.sql -Go back into mysql console, check and optimize all tables Apply third party software if previous actions didn't give any positive result Recovery Toolbox for MySQL https://mysql.recoverytoolbox.com/ -Done Good luck!