mysqlcheck -o --all-databases -u root -p
mysqlcheck -o <db_name> -u root -p
=================================================
mysqlcheck --auto-repair --check --all-databases -u root -p
mysqlcheck --auto-repair --databases <db_name> -u root -p
References:
https://dev.mysql.com/doc/refman/5.6/en/mysqlcheck.html
https://stackoverflow.com/questions/4582832/repair-all-tables-in-one-go
https://stackoverflow.com/questions/5474662/mysql-optimize-all-tables
Article ID: 18
Created On: Mon, Sep 7, 2020 at 8:03 AM
Last Updated On: Wed, Jan 12, 2022 at 7:46 PM
Authored by: Saeed Nobakht [[email protected]]
Online URL: https://www.navel.ir/article/mysql-optimize-repair-all-tables-in-one-go-18.html