Question: Repairing mysql database from command line
Can anyone tell me the process for repairing mysql database from command line?
There are many ways you can repair your MySQL database and tables in it.
The easiest method of Repairing mysql database from command line is to use the mysqlcheck command from command line.
mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
Above command will find and repair the errors. It will also optimize the database for better performance.