GOT

Get Proactive!
PartnerNOC
Apr 8, 2003
1,740
300
363
Chesapeake, VA
cPanel Access Level
DataCenter Provider
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.
 
  • Like
Reactions: USA_Webmaster

cPanelLauren

Technical Support Community Manager
Staff member
Nov 14, 2017
13,304
1,249
313
Houston
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

Well-Known Member
Jun 6, 2014
200
11
68
Lebanon
cPanel Access Level
Root Administrator
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:

Code:
[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)
 
  • Like
Reactions: cPanelLauren