Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Backup Database Errors how to fix?

Discussion in 'Database Discussions' started by grabyourhosting, Sep 12, 2017.

Tags:
  1. grabyourhosting

    grabyourhosting Well-Known Member

    Joined:
    Jan 18, 2007
    Messages:
    59
    Likes Received:
    1
    Trophy Points:
    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)
    
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,220
    Likes Received:
    1,376
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

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

    Thank you.
     
    grabyourhosting likes this.
  3. grabyourhosting

    grabyourhosting Well-Known Member

    Joined:
    Jan 18, 2007
    Messages:
    59
    Likes Received:
    1
    Trophy Points:
    158
    cPanel Access Level:
    Root Administrator
    I opened a ticket and I am awaiting the results of the ticket. Thank you.
     
Loading...

Share This Page