Skip to main content

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. Might you know of a workaround tip to select multiple databases and run repair tool?

Comments

3 comments

Date Votes
  • 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.
    0
  • 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.
    0
  • 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)
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post