check_mysql has determined that there are corrupted database tables

[Gianpiero Colagiacomo]

Since our WHM's last upgrade we've been getting an email reporting corrupted horde database tables:

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)

 

[cPanelMichael]

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.

Hello

You can backup the horde database via:

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.