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.

cPanel Backup error msgs when creating full website backup

Discussion in 'Data Protection' started by JoseSanDiego, May 14, 2016.

  1. JoseSanDiego

    JoseSanDiego Registered

    Joined:
    May 14, 2016
    Messages:
    3
    Likes Received:
    1
    Trophy Points:
    1
    Location:
    San Diego, CA
    cPanel Access Level:
    Website Owner
    I own a simple WordPress site. I use "cPanel --> Backups --> Full Backup --> Download a Full Website Backup." It created a backup of my WordPress site and also sent me an email message with the Raw Log File attached (see attached file below). This Raw Log File contained lots of errors. My "cPanel --> Logs --> Error Log" displays zero messages associated with my website. The WordPress Support Community said this problem is not due to my WordPress files.

    This is a list of the software installed on the host:
    • cPanel Version 56.0 (build 14)
    • Theme x3
    • Apache Version 2.2.31
    • PHP Version 5.4.45
    • MySQL Version 5.5.49-MariaDB
    • Architecture x86_64
    • Operating System linux
    • Path to sendmail /usr/sbin/sendmail
    • Path to Perl /usr/bin/perl
    • Perl Version 5.10.1
    • Kernel Version 2.6.32-573.7.1.el6.x86_64
    cPanel Pro 1.0 (RC1)

    What is causing these cPanel Backup error messages? What can be done?
    Thank you.


    Code:
    --------------------------------------------------------
    [2016-05-14 13:09:28 -0400] pkgacct started.
    [2016-05-14 13:09:28 -0400] pkgacct version 10 - user : mywebsite_name - tarball: 1 - target mysql : default - split: 0 - incremental: 0 - homedir: 1 - mailman: 1 - backup: 0 - archive version: 3 - running with uid 0
    [2016-05-14 13:09:28 -0400] pkgacct using '/usr/local/cpanel/3rdparty/bin/pigz -6 --processes 1 --blocksize 128 --rsyncable' to compress archives
    [2016-05-14 13:09:28 -0400] pkgacct working dir : /home/21777.BIN_ADMIN_CPANEL_BACKUP_PL__.gk3Sv9XaB7WHG9wl.tmp/backup-5.14.2016_13-09-28_mywebsite_name
    [2016-05-14 13:09:28 -0400] Copying Reseller Config...[2016-05-14 13:09:28 -0400] Done
    [2016-05-14 13:09:28 -0400] Copying Suspension Info (if needed)...[2016-05-14 13:09:28 -0400] Done
    [2016-05-14 13:09:28 -0400] Copying SSL certificates, CSRs, and keys...[2016-05-14 13:09:28 -0400] Done
    [2016-05-14 13:09:28 -0400] Storing SSL domain......[2016-05-14 13:09:28 -0400] Done
    [2016-05-14 13:09:28 -0400] Copying Domain Keys....[2016-05-14 13:09:28 -0400] Done
    [2016-05-14 13:09:28 -0400] Copying Counter Data....[2016-05-14 13:09:28 -0400] Done
    [2016-05-14 13:09:28 -0400] Copying Bandwidth Data....Summary databases … done!
    [2016-05-14 13:09:28 -0400] Done
    [2016-05-14 13:09:28 -0400] Copying Dns Zones.......mywebsite_name.com.........[2016-05-14 13:09:29 -0400] Done
    [2016-05-14 13:09:29 -0400] Copying Mail files....[2016-05-14 13:09:29 -0400] Done
    [2016-05-14 13:09:29 -0400] Copying proftpd file....[2016-05-14 13:09:29 -0400] Done
    [2016-05-14 13:09:29 -0400] Copying www logs.......log file sizes [1127400 byte(s)]......mywebsite_name...[2016-05-14 13:09:29 -0400] Done
    [2016-05-14 13:09:29 -0400] Copy userdata...[2016-05-14 13:09:29 -0400] Done
    [2016-05-14 13:09:29 -0400] Copy custom virtualhost templates...[2016-05-14 13:09:29 -0400] Done
    [2016-05-14 13:09:29 -0400] Copying mailman lists and archives....[2016-05-14 13:09:29 -0400] Done copying mailman lists and archives.
    [2016-05-14 13:09:29 -0400] Copying homedir.............
    [2016-05-14 13:09:29 -0400] Done
    [2016-05-14 13:09:29 -0400] Calculating nobody files............
    [2016-05-14 13:09:29 -0400] Done
    [2016-05-14 13:09:29 -0400] Performing “Postgresql” component....
    [2016-05-14 13:09:29 -0400] Completed “Postgresql” component.
    [2016-05-14 13:09:29 -0400] Performing “Mysql” component....
    Load watching suspended due to SIGUSR1
    [2016-05-14 13:09:29 -0400] Determining mysql dbs...[2016-05-14 13:09:29 -0400] ...mysqldump version: 5.5.49...[2016-05-14 13:09:29 -0400] ...mysql version: 5.5...[2016-05-14 13:09:29 -0400] Saving mysql privs...[2016-05-14 13:09:29 -0400] Done
    [2016-05-14 13:09:29 -0400] ...Done
    [2016-05-14 13:09:29 -0400] Storing mysql dbs............
    mywebsite_name[2016-05-14 13:09:30 -0400] mywebsite_name: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'mywebsite_name'': Cannot load from mysql.proc. The table is probably corrupted (1548)
    mywebsite_name.wpub_ai1ec_event_category_meta
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_ai1ec_event_feeds
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_ai1ec_event_instances
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_ai1ec_events
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_commentmeta
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_comments
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_easy_calendar_font_family
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_easy_calendar_manager
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_links
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_options
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_postmeta
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_posts
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_term_relationships
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_term_taxonomy
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_termmeta
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_terms
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_usermeta
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_users
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_wpgmza
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_wpgmza_categories
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_wpgmza_category_maps
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_wpgmza_maps
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_wpgmza_polygon
    note  : The storage engine for the table doesn't support repair
    mywebsite_name.wpub_wpgmza_polylines
    note  : The storage engine for the table doesn't support repair
    [2016-05-14 13:09:30 -0400] mywebsite_name: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'mywebsite_name'': Cannot load from mysql.proc. The table is probably corrupted (1548)
    [2016-05-14 13:09:30 -0400] mywebsite_name: mysqldump failed -- database may be corrupt
    [2016-05-14 13:09:30 -0400] (17181182 bytes)
    [2016-05-14 13:09:30 -0400] Failed to dump database mywebsite_name: The subprocess reported error number 2 when it ended.
    [2016-05-14 13:09:30 -0400]
    [2016-05-14 13:09:30 -0400] ERROR: Failed to dump one or more databases
    [2016-05-14 13:09:30 -0400] ...Done
    Load watching resumed due to SIGUSR2
    [2016-05-14 13:09:30 -0400] Completed “Mysql” component.
    [2016-05-14 13:09:30 -0400] Copying cpuser file.......[2016-05-14 13:09:30 -0400] Done
    [2016-05-14 13:09:30 -0400] Copying crontab file.......[2016-05-14 13:09:30 -0400] Done
    [2016-05-14 13:09:30 -0400] Performing “Quota” component....
    [2016-05-14 13:09:30 -0400] Completed “Quota” component.
    [2016-05-14 13:09:30 -0400] Performing “Integration” component....
    [2016-05-14 13:09:30 -0400] Completed “Integration” component.
    [2016-05-14 13:09:30 -0400] Performing “AuthnLinks” component....
    [2016-05-14 13:09:30 -0400] Completed “AuthnLinks” component.
    [2016-05-14 13:09:30 -0400] Storing Subdomains....
    [2016-05-14 13:09:30 -0400] Done
    [2016-05-14 13:09:30 -0400] Storing Parked Domains....
    [2016-05-14 13:09:30 -0400] Done
    [2016-05-14 13:09:30 -0400] Storing Addon Domains....
    [2016-05-14 13:09:30 -0400] Copying password.......[2016-05-14 13:09:30 -0400] Done
    [2016-05-14 13:09:30 -0400] Copying shell.......[2016-05-14 13:09:30 -0400] Done
    [2016-05-14 13:09:30 -0400] Creating Archive ......................................................
    [2016-05-14 13:09:35 -0400] Done
    [2016-05-14 13:09:35 -0400] pkgacctfile is: /home/21777.BIN_ADMIN_CPANEL_BACKUP_PL__.gk3Sv9XaB7WHG9wl.tmp/backup-5.14.2016_13-09-28_mywebsite_name.tar.gz
    [2016-05-14 13:09:35 -0400] md5sum is: de41101888385161da535a9516467d2c
    [2016-05-14 13:09:35 -0400]
    [2016-05-14 13:09:35 -0400] pkgacct completed
    pkgacctfile is: /home/mywebsite_name/backup-5.14.2016_13-09-28_mywebsite_name.tar.gz
    --------------------------------------------------------
    
    
     
    #1 JoseSanDiego, May 14, 2016
    Last edited by a moderator: May 14, 2016
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,471
    Likes Received:
    199
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Have you spoken with your Hosting Provider about this?
     
  3. JoseSanDiego

    JoseSanDiego Registered

    Joined:
    May 14, 2016
    Messages:
    3
    Likes Received:
    1
    Trophy Points:
    1
    Location:
    San Diego, CA
    cPanel Access Level:
    Website Owner
    Hi,
    I just submitted a "Support Ticket" to them. They provide no telephone support on the weekends. Also, they have a track record of not solving and ignoring "difficult" problems like these, so I'm not optimistic they'll do anything to help.

    I'm hoping you might be able to provide some direction. For example, if you think the root cause lies in my hosting provider's tools or resources, if you would provide me some specific information which I could pass along to them, your information might help them investigate the problem so they might actually try to fix this problem. (My experience is their staff has little technical expertise, which I didn't realize until after I got my website up and running.)

    Thank you for any specific guidance that could be useful to the hosting company, to help them look in the right direction to solve this.

    Also, how serious is this problem?
    Thank you.
     
  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,471
    Likes Received:
    199
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
  5. cPTerrance

    cPTerrance *nix Technical Analyst II / Migrations Specialist
    Staff Member

    Joined:
    Jul 9, 2015
    Messages:
    72
    Likes Received:
    8
    Trophy Points:
    8
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Looks like your Hosting Provider may actually have issues on there side as well, it appears that the "mysql" database may have some issues:

     
  6. JoseSanDiego

    JoseSanDiego Registered

    Joined:
    May 14, 2016
    Messages:
    3
    Likes Received:
    1
    Trophy Points:
    1
    Location:
    San Diego, CA
    cPanel Access Level:
    Website Owner

    Hi, Thank you for this information. I'll send this information to my hosting provider
     
    Infopro likes this.
Loading...

Share This Page