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.

Error in database backup

Discussion in 'Database Discussions' started by hamed5034, Mar 7, 2014.

  1. hamed5034

    hamed5034 Member

    Joined:
    Nov 21, 2013
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello,
    I have a problem in getting backup for some of my databases.

    Code:
    Storing mysql dbs............
    rebecmus_a.........
    rebecmus_a.ggjbk0_TABLE_STATISTICS                 OK
    rebecmus_a.ggjbk0_TABLE_STATISTICS_RAW             OK
    rebecmus_a.ggjbk0_aiowps_failed_logins             OK
    rebecmus_a.ggjbk0_aiowps_global_meta               OK
    rebecmus_a.ggjbk0_aiowps_login_activity            OK
    rebecmus_a.ggjbk0_aiowps_login_lockdown            OK
    rebecmus_a.ggjbk0_commentmeta                      OK
    rebecmus_a.ggjbk0_comments                         OK
    rebecmus_a.ggjbk0_dlmc                             OK
    rebecmus_a.ggjbk0_kklike
    Error    : Table 'rebecmus_a.ggjbk0_kklike' doesn't exist
    status   : Operation failed
    rebecmus_a.ggjbk0_kklikeuser
    Error    : Table 'rebecmus_a.ggjbk0_kklikeuser' doesn't exist
    status   : Operation failed
    rebecmus_a.ggjbk0_like_dislike_counters
    Error    : Table 'rebecmus_a.ggjbk0_like_dislike_counters' doesn't exist
    status   : Operation failed
    rebecmus_a.ggjbk0_likeit                           OK
    rebecmus_a.ggjbk0_links                            OK
    rebecmus_a.ggjbk0_newsletter                       OK
    rebecmus_a.ggjbk0_newsletter_emails                OK
    rebecmus_a.ggjbk0_newsletter_stats                 OK
    rebecmus_a.ggjbk0_options                          OK
    rebecmus_a.ggjbk0_postmeta                         OK
    rebecmus_a.ggjbk0_posts                            OK
    rebecmus_a.ggjbk0_rating_scores
    Error    : Table 'rebecmus_a.ggjbk0_rating_scores' doesn't exist
    status   : Operation failed
    rebecmus_a.ggjbk0_statistics_useronline
    Error    : Table 'rebecmus_a.ggjbk0_statistics_useronline' doesn't exist
    status   : Operation failed
    rebecmus_a.ggjbk0_statistics_visit
    Error    : Table 'rebecmus_a.ggjbk0_statistics_visit' doesn't exist
    status   : Operation failed
    And size of my sql file is lower than my database size.
    What should I do to resolve this issue?

    Regards
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,666
    Likes Received:
    646
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    It appears there could be corruption with that database. Try checking the database on the server to verify that with a command such as:

    Code:
    mysqlcheck database_name
    You should be able to use the mysqldump utility to backup a database successfully so you know it will work during the account backup generation.

    Thank you.
     
  3. hamed5034

    hamed5034 Member

    Joined:
    Nov 21, 2013
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello,

    The out put of:
    Code:
    mysqlcheck rebecmus_a
    is:
    Code:
    rebecmus_a.ggjbk0_TABLE_STATISTICS                 OK
    rebecmus_a.ggjbk0_TABLE_STATISTICS_RAW             OK
    rebecmus_a.ggjbk0_aiowps_failed_logins             OK
    rebecmus_a.ggjbk0_aiowps_global_meta               OK
    rebecmus_a.ggjbk0_aiowps_login_activity            OK
    rebecmus_a.ggjbk0_aiowps_login_lockdown            OK
    rebecmus_a.ggjbk0_commentmeta                      OK
    rebecmus_a.ggjbk0_comments                         OK
    rebecmus_a.ggjbk0_dlmc                             OK
    rebecmus_a.ggjbk0_kklike
    Error    : Table 'rebecmus_a.ggjbk0_kklike' doesn't exist
    status   : Operation failed
    rebecmus_a.ggjbk0_kklikeuser
    Error    : Table 'rebecmus_a.ggjbk0_kklikeuser' doesn't exist
    status   : Operation failed
    rebecmus_a.ggjbk0_like_dislike_counters
    Error    : Table 'rebecmus_a.ggjbk0_like_dislike_counters' doesn't exist
    status   : Operation failed
    rebecmus_a.ggjbk0_likeit                           OK
    rebecmus_a.ggjbk0_links                            OK
    rebecmus_a.ggjbk0_newsletter                       OK
    rebecmus_a.ggjbk0_newsletter_emails                OK
    rebecmus_a.ggjbk0_newsletter_stats                 OK
    rebecmus_a.ggjbk0_options                          OK
    rebecmus_a.ggjbk0_postmeta                         OK
    rebecmus_a.ggjbk0_posts                            OK
    rebecmus_a.ggjbk0_rating_scores
    Error    : Table 'rebecmus_a.ggjbk0_rating_scores' doesn't exist
    status   : Operation failed
    rebecmus_a.ggjbk0_statistics_useronline
    Error    : Table 'rebecmus_a.ggjbk0_statistics_useronline' doesn't exist
    status   : Operation failed
    rebecmus_a.ggjbk0_statistics_visit
    Error    : Table 'rebecmus_a.ggjbk0_statistics_visit' doesn't exist
    status   : Operation failed
    rebecmus_a.ggjbk0_statistics_visitor
    Error    : Table 'rebecmus_a.ggjbk0_statistics_visitor' doesn't exist
    status   : Operation failed
    rebecmus_a.ggjbk0_term_relationships               OK
    rebecmus_a.ggjbk0_term_taxonomy                    OK
    rebecmus_a.ggjbk0_terms                            OK
    rebecmus_a.ggjbk0_usermeta                         OK
    rebecmus_a.ggjbk0_users                            OK
    rebecmus_a.ggjbk0_wti_like_post
    Error    : Table 'rebecmus_a.ggjbk0_wti_like_post' doesn't exist
    status   : Operation failed
    rebecmus_a.ggjbk0_yarpp_related_cache              OK
    
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,666
    Likes Received:
    646
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  5. hamed5034

    hamed5034 Member

    Joined:
    Nov 21, 2013
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello,

    Thank you.
    Is there any solution for this issue? I did not disable InnoDB or delete data associated whit it. (Who could I check that everything is OK about InnoDB?)
    Litespeed is running on my server with CloudLinux.

    Regards
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,666
    Likes Received:
    646
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  7. hamed5034

    hamed5034 Member

    Joined:
    Nov 21, 2013
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello again,

    There are no error during restarting mysql:
    Code:
    root@server [~]# service mysql restart
    Shutting down MySQL....                                    [  OK  ]
    Starting MySQL..                                           [  OK  ]
    root@server [~]#
    
    And this is my /etc/my.cnf :
    Code:
    [mysqld]
    datadir = /home/mysql
    #socket=/home/mysql/mysql.sock
    innodb_file_per_table=1
    default-storage-engine=MyISAM
    max_allowed_packet=512M
    query_cache_size = 4G
    query_cache_type=1
    thread_cache_size = 384
    join_buffer_size=4G
    max_connections=1000
    local-infile=0
    table_cache= 10000
    open_files_limit = 81920
    tmp_table_size=256M
    max_heap_table_size=256M
    wait_timeout=5
    
    Do you see any problem? And do you think my DB is simply corrupt and needs to be repaired?

    Regards
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,666
    Likes Received:
    646
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
     
  9. hamed5034

    hamed5034 Member

    Joined:
    Nov 21, 2013
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello,

    There is no error in server.domain.com.err after restarting mysql too.

    Regards
     
  10. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,666
    Likes Received:
    646
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    In that case, I suggest reviewing the link referenced in my earlier post or consulting with a qualified system administrator to determine if there are any specific problems with the tables.

    Thank you.
     
Loading...

Share This Page