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.

check_mysql has determined that there are corrupted database tables

Discussion in 'Database Discussions' started by Gianpiero Colagiacomo, Aug 10, 2015.

  1. Gianpiero Colagiacomo

    Joined:
    Aug 10, 2015
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    England., UK
    cPanel Access Level:
    Root Administrator
    Since our WHM's last upgrade we've been getting an email reporting corrupted horde database tables:

    Code:
    horde.content_schema_info
    Error : Table 'horde.content_schema_info' doesn't exist
    horde.horde_alarm_schema_info
    Error : Table 'horde.horde_alarm_schema_info' doesn't exist
    horde.horde_alarms
    Error : Table 'horde.horde_alarms' doesn't exist
    horde.horde_auth_schema_info
    Error : Table 'horde.horde_auth_schema_info' doesn't exist
    horde.horde_cache
    Error : Table 'horde.horde_cache' doesn't exist
    horde.horde_cache_schema_info
    Error : Table 'horde.horde_cache_schema_info' doesn't exist
    horde.horde_core_schema_info
    Error : Table 'horde.horde_core_schema_info' doesn't exist
    horde.horde_datatree
    Error : Table 'horde.horde_datatree' doesn't exist
    horde.horde_datatree_attributes
    Error : Table 'horde.horde_datatree_attributes' doesn't exist
    horde.horde_dav_collections
    Error : Table 'horde.horde_dav_collections' doesn't exist
    horde.horde_dav_objects
    Error : Table 'horde.horde_dav_objects' doesn't exist
    horde.horde_dav_schema_info
    Error : Table 'horde.horde_dav_schema_info' doesn't exist
    horde.horde_group_schema_info
    Error : Table 'horde.horde_group_schema_info' doesn't exist
    horde.horde_groups
    Error : Table 'horde.horde_groups' doesn't exist
    horde.horde_groups_members
    Error : Table 'horde.horde_groups_members' doesn't exist
    horde.horde_histories
    Error : Table 'horde.horde_histories' doesn't exist
    horde.horde_histories_modseq
    Error : Table 'horde.horde_histories_modseq' doesn't exist
    horde.horde_history_schema_info
    Error : Table 'horde.horde_history_schema_info' doesn't exist
    horde.horde_imap_client_data
    Error : Table 'horde.horde_imap_client_data' doesn't exist
    horde.horde_imap_client_message
    Error : Table 'horde.horde_imap_client_message' doesn't exist
    horde.horde_imap_client_metadata
    Error : Table 'horde.horde_imap_client_metadata' doesn't exist
    horde.horde_imap_client_schema_info
    Error : Table 'horde.horde_imap_client_schema_info' doesn't exist
    horde.horde_lock_schema_info
    Error : Table 'horde.horde_lock_schema_info' doesn't exist
    horde.horde_locks
    Error : Table 'horde.horde_locks' doesn't exist
    horde.horde_muvfs
    Error : Table 'horde.horde_muvfs' doesn't exist
    horde.horde_perms
    Error : Table 'horde.horde_perms' doesn't exist
    horde.horde_perms_schema_info
    Error : Table 'horde.horde_perms_schema_info' doesn't exist
    horde.horde_prefs
    Error : Table 'horde.horde_prefs' doesn't exist
    horde.horde_prefs_schema_info
    Error : Table 'horde.horde_prefs_schema_info' doesn't exist
    horde.horde_queue_schema_info
    Error : Table 'horde.horde_queue_schema_info' doesn't exist
    horde.horde_queue_tasks
    Error : Table 'horde.horde_queue_tasks' doesn't exist
    horde.horde_sessionhandler
    Error : Table 'horde.horde_sessionhandler' doesn't exist
    horde.horde_sessionhandler_schema_info
    Error : Table 'horde.horde_sessionhandler_schema_info' doesn't exist
    horde.horde_signups
    Error : Table 'horde.horde_signups' doesn't exist
    horde.horde_syncml_anchors
    Error : Table 'horde.horde_syncml_anchors' doesn't exist
    horde.horde_syncml_map
    Error : Table 'horde.horde_syncml_map' doesn't exist
    horde.horde_syncml_schema_info
    Error : Table 'horde.horde_syncml_schema_info' doesn't exist
    horde.horde_token_schema_info
    Error : Table 'horde.horde_token_schema_info' doesn't exist
    horde.horde_tokens
    Error : Table 'horde.horde_tokens' doesn't exist
    horde.horde_users
    Error : Table 'horde.horde_users' doesn't exist
    horde.horde_vfs
    Error : Table 'horde.horde_vfs' doesn't exist
    horde.horde_vfs_schema_info
    Error : Table 'horde.horde_vfs_schema_info' doesn't exist
    horde.imp_schema_info
    Error : Table 'horde.imp_schema_info' doesn't exist
    horde.imp_sentmail
    Error : Table 'horde.imp_sentmail' doesn't exist
    horde.ingo_forwards
    Error : Table 'horde.ingo_forwards' doesn't exist
    horde.ingo_lists
    Error : Table 'horde.ingo_lists' doesn't exist
    horde.ingo_rules
    Error : Table 'horde.ingo_rules' doesn't exist
    horde.ingo_schema_info
    Error : Table 'horde.ingo_schema_info' doesn't exist
    horde.ingo_shares
    Error : Table 'horde.ingo_shares' doesn't exist
    horde.ingo_shares_groups
    Error : Table 'horde.ingo_shares_groups' doesn't exist
    horde.ingo_shares_users
    Error : Table 'horde.ingo_shares_users' doesn't exist
    horde.ingo_sharesng
    Error : Table 'horde.ingo_sharesng' doesn't exist
    horde.ingo_sharesng_groups
    Error : Table 'horde.ingo_sharesng_groups' doesn't exist
    horde.ingo_sharesng_users
    Error : Table 'horde.ingo_sharesng_users' doesn't exist
    horde.ingo_spam
    Error : Table 'horde.ingo_spam' doesn't exist
    horde.ingo_vacations
    Error : Table 'horde.ingo_vacations' doesn't exist
    horde.kronolith_events
    Error : Table 'horde.kronolith_events' doesn't exist
    horde.kronolith_events_geo
    Error : Table 'horde.kronolith_events_geo' doesn't exist
    horde.kronolith_events_mysqlgeo
    Error : Table 'horde.kronolith_events_mysqlgeo' doesn't exist
    horde.kronolith_resources
    Error : Table 'horde.kronolith_resources' doesn't exist
    horde.kronolith_schema_info
    Error : Table 'horde.kronolith_schema_info' doesn't exist
    horde.kronolith_shares
    Error : Table 'horde.kronolith_shares' doesn't exist
    horde.kronolith_shares_groups
    Error : Table 'horde.kronolith_shares_groups' doesn't exist
    horde.kronolith_shares_users
    Error : Table 'horde.kronolith_shares_users' doesn't exist
    horde.kronolith_sharesng
    Error : Table 'horde.kronolith_sharesng' doesn't exist
    horde.kronolith_sharesng_groups
    Error : Table 'horde.kronolith_sharesng_groups' doesn't exist
    horde.kronolith_sharesng_users
    Error : Table 'horde.kronolith_sharesng_users' doesn't exist
    horde.kronolith_storage
    Error : Table 'horde.kronolith_storage' doesn't exist
    horde.mnemo_memos
    Error : Table 'horde.mnemo_memos' doesn't exist
    horde.mnemo_schema_info
    Error : Table 'horde.mnemo_schema_info' doesn't exist
    horde.mnemo_shares
    Error : Table 'horde.mnemo_shares' doesn't exist
    horde.mnemo_shares_groups
    Error : Table 'horde.mnemo_shares_groups' doesn't exist
    horde.mnemo_shares_users
    Error : Table 'horde.mnemo_shares_users' doesn't exist
    horde.mnemo_sharesng
    Error : Table 'horde.mnemo_sharesng' doesn't exist
    horde.mnemo_sharesng_groups
    Error : Table 'horde.mnemo_sharesng_groups' doesn't exist
    horde.mnemo_sharesng_users
    Error : Table 'horde.mnemo_sharesng_users' doesn't exist
    horde.nag_schema_info
    Error : Table 'horde.nag_schema_info' doesn't exist
    horde.nag_shares
    Error : Table 'horde.nag_shares' doesn't exist
    horde.nag_shares_groups
    Error : Table 'horde.nag_shares_groups' doesn't exist
    horde.nag_shares_users
    Error : Table 'horde.nag_shares_users' doesn't exist
    horde.nag_sharesng
    Error : Table 'horde.nag_sharesng' doesn't exist
    horde.nag_sharesng_groups
    Error : Table 'horde.nag_sharesng_groups' doesn't exist
    horde.nag_sharesng_users
    Error : Table 'horde.nag_sharesng_users' doesn't exist
    horde.nag_tasks
    Error : Table 'horde.nag_tasks' doesn't exist
    horde.rampage_objects
    Error : Table 'horde.rampage_objects' doesn't exist
    horde.rampage_tag_stats
    Error : Table 'horde.rampage_tag_stats' doesn't exist
    horde.rampage_tagged
    Error : Table 'horde.rampage_tagged' doesn't exist
    horde.rampage_tags
    Error : Table 'horde.rampage_tags' doesn't exist
    horde.rampage_types
    Error : Table 'horde.rampage_types' doesn't exist
    horde.rampage_user_tag_stats
    Error : Table 'horde.rampage_user_tag_stats' doesn't exist
    horde.rampage_users
    Error : Table 'horde.rampage_users' doesn't exist
    horde.trean_bookmarks
    Error : Table 'horde.trean_bookmarks' doesn't exist
    horde.trean_schema_info
    Error : Table 'horde.trean_schema_info' doesn't exist
    horde.turba_objects
    Error : Table 'horde.turba_objects' doesn't exist
    horde.turba_schema_info
    Error : Table 'horde.turba_schema_info' doesn't exist
    horde.turba_shares
    Error : Table 'horde.turba_shares' doesn't exist
    horde.turba_shares_groups
    Error : Table 'horde.turba_shares_groups' doesn't exist
    horde.turba_shares_users
    Error : Table 'horde.turba_shares_users' doesn't exist
    horde.turba_sharesng
    Error : Table 'horde.turba_sharesng' doesn't exist
    horde.turba_sharesng_groups
    Error : Table 'horde.turba_sharesng_groups' doesn't exist
    horde.turba_sharesng_users
    Error : Table 'horde.turba_sharesng_users' doesn't exist
    
    Now I understand that Horde was updated in this last WHM upgrade and that the upgrade changed Horde from using MySQL to another database so I'm wondering if what I should be doing is dropping the Horde db entirely? Can anyone offer advice on what we ought to do to resolve this please? We don't use webmail so its not causing any operational issues but it would be nice to have everything in order and to stop receiving this email.

    Thanks!

    Forgot to post the WHM version:
    • WHM 11.50.0 (build 29)
     
    #1 Gianpiero Colagiacomo, Aug 10, 2015
    Last edited by a moderator: Aug 10, 2015
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    671
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    You can backup the horde database via:

    Code:
    mysqldump horde > /root/path/to/horde.sql
    You can then delete the database via phpMyAdmin or via the MySQL command line if you do not use Webmail and don't need to verify the data was converted to the SQLite databases successfully.

    Thank you.
     
Loading...

Share This Page