Backup Database Errors how to fix?
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.
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)
-
Hello, Could you open a support ticket using the link in my signature so we can take a closer look? Thank you. 0 -
I opened a ticket and I am awaiting the results of the ticket. Thank you. 0
Please sign in to leave a comment.
Comments
2 comments