Bulk Repair MySQL Database

[USA_Webmaster]

How do I bulk run repair tool in WHM or even cPanel? I thought I could do it in WHM, did I overlook it? When I tried using CTRL to multiple select, it was not allowed.

• Home »SQL Services »Repair a MySQL
• Repair a MySQL Database - 11.42 Documentation - cPanel Documentation

Might you know of a workaround tip to select multiple databases and run repair tool?

 

[GOT]

I don't know of a way in whm but from command line you can run

mysqlcheck --all-databases -A

And that will check and repair all tables in all databases.

 

[cPanelLauren]

Hi @USA_Webmaster

The suggestion provided by @GOT is the most efficient, you can access all databases through WHM>>SQL Services>>PHPMyAdmin and you can repair databases from WHM>>SQL Services>>Repair a MySQL database but neither of these allow for bulk repair.

 

[psytanium]

Hi @USA_Webmaster

The suggestion provided by @GOT is the most efficient, you can access all databases through WHM>>SQL Services>>PHPMyAdmin and you can repair databases from WHM>>SQL Services>>Repair a MySQL database but neither of these allow for bulk repair.

I run the command "mysqlcheck --all-databases -A" to repair all databases. Hopefully tomorrow the backup complete properly. Will post the results here. Thanks

Attached log:

[2020-03-22 02:50:27 +0200]
[2020-03-22 02:50:27 +0200] homefiles is: 6475
[2020-03-22 02:50:27 +0200] pkgacct completed
[2020-03-22 02:50:28 +0200] info [backup] Successfully backed up account “suzyalmawadda” to “/backup/2020-03-22/accounts”
[2020-03-22 02:50:28 +0200] info [backup] Adding metadata information for suzyalmawadda to backup at /backup/2020-03-22
[2020-03-22 02:50:33 +0200] info [backup] Queuing daily backup copy of “suzyalmawadda” for transport of “/backup/2020-03-22/accounts/suzyalmawadda.tar.gz” to “2020-03-22/accounts/suzyalmawadda.tar.gz”
[2020-03-22 02:50:33 +0200] info [backup] This particular transport will be queued with keep_local = 1 , based on the need to copy weekly () and/or monthly () copies as well.
[2020-03-22 02:50:33 +0200] info [backup] Queuing transport of file: /backup/2020-03-22/accounts/suzyalmawadda.tar.gz
[2020-03-22 02:50:33 +0200] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:17731
[2020-03-22 02:50:33 +0200] info [backup] leaving queue_backup_transport_item
[2020-03-22 02:50:33 +0200] info [backup] checking backup for morcotra
[2020-03-22 02:50:33 +0200] info [backup] Queuing transport of meta file: /backup/2020-03-22/accounts/.master.meta
[2020-03-22 02:50:33 +0200] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:17732
[2020-03-22 02:50:33 +0200] info [backup] leaving queue_backup_transport_item
[2020-03-22 02:50:33 +0200] info [backup] Queuing transport of file: /backup/2020-03-22/backup_incomplete
[2020-03-22 02:50:33 +0200] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:17733
[2020-03-22 02:50:33 +0200] info [backup] leaving queue_backup_transport_item
[2020-03-22 02:50:33 +0200] warn [backup] Pruning of backup files skipped due to errors. at /usr/local/cpanel/bin/backup line 395.
bin::backup::run("bin::backup") called at /usr/local/cpanel/bin/backup line 120
[2020-03-22 02:50:33 +0200] info [backup] Scheduling backup metadata vacuum
[2020-03-22 02:50:34 +0200] info [backup] Queuing transport reporter
[2020-03-22 02:50:34 +0200] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:17734
[2020-03-22 02:50:34 +0200] info [backup] leaving queue_backup_transport_item
[2020-03-22 02:50:34 +0200] info [backup] Completed at Sun Mar 22 02:50:34 2020
[2020-03-22 02:50:34 +0200] info [backup] Final state is Backup::PartialFailure (0)