Hosting

Bulk Repair MySQL Database

Using WHM / cPanel is good stuff maybe not powerful enough. If you have multiple MySQL Databases and want to bulk run repair tool – it’s not possible unless you SSH / Command Line it. Run the command mysqlcheck --all-databases --fast to bulk (or mass) repair all MySQL databases. If you remove the --fast from command, database repair will take longer but do a better job because it’s checking ALL tables, not just the tables that have not been closed properly. https://devhints.io/mysql https://dev.mysql.com/doc/refman/8.0/en/mysqlcheck.html#option_mysqlcheck_fast

Using WHM / cPanel is good stuff maybe not powerful enough. If you have multiple MySQL Databases and want to bulk run repair tool – it’s not possible unless you SSH / Command Line it.

Run the command mysqlcheck --all-databases --fast to bulk (or mass) repair all MySQL databases.

If you remove the --fast from command, database repair will take longer but do a better job because it’s checking ALL tables, not just the tables that have not been closed properly.

Leave a Comment

 

Consider sharing this post at whatever time suits you old sport.