PPMB Table Status Utility

Table Status as of Fri Apr 26 23:16:12 CDT 2024

This is a live, real time report on the status of the tables in the PPMB forum database using the MySQL CHECK TABLE command. Every table, including some that may be no longer used (those with the "phpbb_" prefix as opposed to the "phpbb3_" prefix, for example) is checked.

Just because CHECK TABLE reports a table as corrupt does not mean that the table requires an immediate REBUILD TABLE or other intervention. A frequent cuase of tables failing CHECK TABLE is the inability to CHECK TABLE to open them, which could be caused by something as innocuous as lock applied during update. If a table is reported as corrupt because it can't be opened, run the report again to see if the table is still reported as corrupt. If not, there is probably no need to worry.

A table that repeatedly reports corruption run after run is probably a cause for concern. Please mention any tables you notice exhibiting this in the Mods forum.

Running mysql --force --html --wait --user=thepaper_dbUser --password=XXXXXXXXX --database=thepaper_PPMBDB --host=localhost

mysql --force --html --wait --user=thepaper_dbUser --password=dbU$3r --database=thepaper_PPMBDB --host=localhost Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_acl_groups check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_acl_options check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_acl_roles check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_acl_roles_data check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_acl_users check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_attachments check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_banlist check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_bbcodes check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_bookmarks check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_bots check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_config check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_confirm check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_disallow check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_drafts check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_extension_groups check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_extensions check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_forums check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_forums_access check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_forums_track check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_forums_watch check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_groups check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_icons check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_lang check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_log check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_moderator_cache check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_modules check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_poll_options check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_poll_votes check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_posts check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_privmsgs check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_privmsgs_folder check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_privmsgs_rules check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_privmsgs_to check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_profile_fields check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_profile_fields_data check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_profile_fields_lang check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_profile_lang check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_ranks check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_reports check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_reports_reasons check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_search_results check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_search_wordlist check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_search_wordmatch check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_sessions check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_sessions_keys check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_sitelist check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_smilies check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_styles check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_styles_imageset check Error Table 'thepaper_PPMBDB.phpbb3_styles_imageset' doesn't exist thepaper_PPMBDB.phpbb3_styles_imageset check status Operation failed Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_styles_imageset_data check Error Table 'thepaper_PPMBDB.phpbb3_styles_imageset_data' doesn't exist thepaper_PPMBDB.phpbb3_styles_imageset_data check status Operation failed Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_styles_template check Error Table 'thepaper_PPMBDB.phpbb3_styles_template' doesn't exist thepaper_PPMBDB.phpbb3_styles_template check status Operation failed Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_styles_template_data check Error Table 'thepaper_PPMBDB.phpbb3_styles_template_data' doesn't exist thepaper_PPMBDB.phpbb3_styles_template_data check status Operation failed Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_styles_theme check Error Table 'thepaper_PPMBDB.phpbb3_styles_theme' doesn't exist thepaper_PPMBDB.phpbb3_styles_theme check status Operation failed Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_topics check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_topics_posted check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_topics_track check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_topics_watch check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_user_group check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_users check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_warnings check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_words check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb3_zebra check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_attach_quota check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_attachments check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_attachments_config check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_attachments_desc check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_auth_access check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_banlist check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_categories check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_config check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_confirm check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_disallow check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_easymod check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_extension_groups check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_extensions check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_forbidden_extensions check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_forum_prune check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_forums check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_groups check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_posts check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_posts_text check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_privmsgs check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_privmsgs_text check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_quota_limits check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_ranks check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_search_results check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_search_wordlist check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_search_wordmatch check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_sessions check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_sessions_keys check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_smilies check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_themes check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_themes_name check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_topics check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_topics_watch check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_user_group check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_users check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_vote_desc check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_vote_results check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_vote_voters check status OK Table Op Msg_type Msg_text thepaper_PPMBDB.phpbb_words check status OK

Table	Op	Msg_type	Msg_text
thepaper_PPMBDB.phpbb3_styles_imageset	check	Error	Table 'thepaper_PPMBDB.phpbb3_styles_imageset' doesn't exist
thepaper_PPMBDB.phpbb3_styles_imageset	check	status	Operation failed

Table	Op	Msg_type	Msg_text
thepaper_PPMBDB.phpbb3_styles_imageset_data	check	Error	Table 'thepaper_PPMBDB.phpbb3_styles_imageset_data' doesn't exist
thepaper_PPMBDB.phpbb3_styles_imageset_data	check	status	Operation failed

Table	Op	Msg_type	Msg_text
thepaper_PPMBDB.phpbb3_styles_template	check	Error	Table 'thepaper_PPMBDB.phpbb3_styles_template' doesn't exist
thepaper_PPMBDB.phpbb3_styles_template	check	status	Operation failed

Table	Op	Msg_type	Msg_text
thepaper_PPMBDB.phpbb3_styles_template_data	check	Error	Table 'thepaper_PPMBDB.phpbb3_styles_template_data' doesn't exist
thepaper_PPMBDB.phpbb3_styles_template_data	check	status	Operation failed

Table	Op	Msg_type	Msg_text
thepaper_PPMBDB.phpbb3_styles_theme	check	Error	Table 'thepaper_PPMBDB.phpbb3_styles_theme' doesn't exist
thepaper_PPMBDB.phpbb3_styles_theme	check	status	Operation failed