Backup Database Errors how to fix?

grabyourhosting

Well-Known Member
Jan 18, 2007
96
6
158
cPanel Access Level
Root Administrator
I keep getting these errors on two of my servers. It's driving me nuts because what I am afraid of if I transfer the data to a different server it's not going to create the accounts properly. I had many database issues with two servers of mine. Please suggest what to do or either allow the errors to be fixed automatically. I don't know what ssh commands to run etc. Problem is it doesn't tell me much. It just tells me to fix the database errors. That's not going to be good. I should be able to delete the databases and the process should go through. Thank you.

The backup process completed, but 16 errors occurred.
The system started a separate transport process for remote backup destinations. When the transport completes, the system will send an additional notification with the status of the transport.


Code:
The backup process encountered the following errors:
travelin_wp4[2017-09-12 02:27:43 -0400] travelin_wp4: mysqldump: Got error: 1049: Unknown database 'data_wp4' when selecting the database
[2017-09-12 02:27:43 -0400] travelin_wp4: mysqldump: Got error: 1049: Unknown database 'data_wp4' when selecting the database
[2017-09-12 02:27:43 -0400] travelin_wp4: mysqldump: Got error: 1049: Unknown database 'data_wp4' when selecting the database
data_wp3[2017-09-12 02:27:43 -0400] travelin_wp3: mysqldump: Got error: 1049: Unknown database 'datawp3' when selecting the database
[2017-09-12 02:27:43 -0400] travelin_wp3: mysqldump: Got error: 1049: Unknown database 'travelin_wp3' when selecting the database
[2017-09-12 02:27:43 -0400] travelin_wp3: mysqldump: Got error: 1049: Unknown database 'travelin_wp3' when selecting the database
travelin_wordpress[2017-09-12 02:27:43 -0400] travelin_wordpress: mysqldump: Got error: 1146: Table 'data_wordpress.tiwp_wfFileMods' doesn't exist when using LOCK TABLES
travelin_wp2[2017-09-12 02:27:44 -0400] travelin_wp2: mysqldump: Got error: 1049: Unknown database 'data_wp2' when selecting the database
[2017-09-12 02:27:44 -0400] data_wp2: mysqldump: Got error: 1049: Unknown database 'data_wp2' when selecting the database
[2017-09-12 02:27:44 -0400] tdata_wp2: mysqldump: Got error: 1049: Unknown database 'data_wp2' when selecting the database
greenden_wp_main[2017-09-12 02:54:44 -0400] greenden_wp_main: mysqldump: Got error: 1049: Unknown database 'greenden_wp_main' when selecting the database
[2017-09-12 02:54:44 -0400] greenden_wp_main: mysqldump: Got error: 1049: Unknown database 'greenden_wp_main' when selecting the database
[2017-09-12 02:54:44 -0400] greenden_wp_main: mysqldump: Got error: 1049: Unknown database 'greenden_wp_main' when selecting the database
data_wp[2017-09-12 03:42:24 -0400] heartlan_wp: mysqldump: Got error: 1146: Table 'data_wp.hffwp_wfFileMods' doesn't exist when using LOCK TABLES
theeyece_wp[2017-09-12 04:07:31 -0400] theeyece_wp: mysqldump: Got error: 1146: Table 'data_wp.tecwp_wfHoover' doesn't exist when using LOCK TABLES
trojanho_wp[2017-09-12 04:20:21 -0400] trojanho_wp: mysqldump: Got error: 1146: Table 'tdata_wp.thwp_wfNet404s' doesn't exist when using LOCK TABLES

Review the attached log “/usr/local/cpanel/logs/cpbackup/1505196001.log” for further details.
[2017-09-12 05:29:01 -0400] size is: 68310413
[2017-09-12 05:29:01 -0400] 
[2017-09-12 05:29:01 -0400] homesize is: 117923840
[2017-09-12 05:29:01 -0400] 
[2017-09-12 05:29:01 -0400] homefiles is: 3948
[2017-09-12 05:29:01 -0400] pkgacct completed
[2017-09-12 05:29:02 -0400] info [backup] Queuing daily backup copy of “saltcave” for transport of “/backups/2017-09-12/accounts/saltcave.tar.gz” to “2017-09-12/accounts/saltcave.tar.gz”
[2017-09-12 05:29:03 -0400] info [backup] Queuing transport of file: /backups/2017-09-12/accounts/saltcave.tar.gz
[2017-09-12 05:29:03 -0400] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:12586
[2017-09-12 05:29:03 -0400] info [backup] leaving queue_backup_transport_item
[2017-09-12 05:29:03 -0400] info [backup] Queuing transport of file: /backups/2017-09-12/accounts/saltcave-=-meta
[2017-09-12 05:29:03 -0400] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:12587
[2017-09-12 05:29:03 -0400] info [backup] leaving queue_backup_transport_item
[2017-09-12 05:29:03 -0400] info [backup] Queuing transport of file: /backups/2017-09-12/backup_incomplete
[2017-09-12 05:29:03 -0400] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:12588
[2017-09-12 05:29:03 -0400] info [backup] leaving queue_backup_transport_item
[2017-09-12 05:29:03 -0400] info [backup] Pruning backup directory: /backups/2017-09-07
[2017-09-12 05:29:03 -0400] info [backup] Queuing prune operation for remote destination daily backups
[2017-09-12 05:29:03 -0400] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:12589
[2017-09-12 05:29:03 -0400] info [backup] leaving queue_backup_transport_item
[2017-09-12 05:29:03 -0400] info [backup] Queuing transport reporter
[2017-09-12 05:29:03 -0400] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:12590
[2017-09-12 05:29:03 -0400] info [backup] leaving queue_backup_transport_item
[2017-09-12 05:29:03 -0400] info [backup] Completed at Tue Sep 12 05:29:03 2017
[2017-09-12 05:29:03 -0400] info [backup] Final state is Backup::PartialFailure (0)
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,227
463
Hello,

Could you open a support ticket using the link in my signature so we can take a closer look?

Thank you.
 
  • Like
Reactions: grabyourhosting