Difference between revisions of "Mysqlcheck"

From wikieduonline
Jump to navigation Jump to search
(Created page with " {{Mysqlcheck}}")
 
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
 +
{{lc}}
  
 +
[[mysqlcheck --repair --all-databases]]
 +
<pre>
 +
mysql.column_stats                                OK
 +
mysql.columns_priv                                OK
 +
mysql.db                                          OK
 +
mysql.event                                        OK
 +
mysql.func                                        OK
 +
mysql.global_priv                                  OK
 +
mysql.gtid_slave_pos
 +
note    : The storage engine for the table doesn't support repair
 +
mysql.help_category                                OK
 +
mysql.help_keyword                                OK
 +
mysql.help_relation                                OK
 +
mysql.help_topic                                  OK
 +
mysql.index_stats                                  OK
 +
mysql.innodb_index_stats
 +
note    : The storage engine for the table doesn't support repair
 +
mysql.innodb_table_stats
 +
note    : The storage engine for the table doesn't support repair
 +
mysql.plugin                                      OK
 +
mysql.proc                                        OK
 +
mysql.procs_priv                                  OK
 +
mysql.proxies_priv                                OK
 +
mysql.roles_mapping                                OK
 +
mysql.servers                                      OK
 +
mysql.table_stats                                  OK
 +
mysql.tables_priv                                  OK
 +
mysql.time_zone                                    OK
 +
mysql.time_zone_leap_second                        OK
 +
mysql.time_zone_name                              OK
 +
mysql.time_zone_transition                        OK
 +
mysql.time_zone_transition_type                    OK
 +
mysql.transaction_registry
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.actor
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.archive
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.bot_passwords
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.category
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.categorylinks
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.change_tag
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.change_tag_def
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.comment
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.content
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.content_models
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.externallinks
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.filearchive
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.image
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.imagelinks
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.interwiki
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.ip_changes
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.ipblocks
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.ipblocks_restrictions
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.iwlinks
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.job
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.l10n_cache
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.langlinks
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.log_search
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.logging
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.module_deps
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.objectcache
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.oldimage
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.page
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.page_props
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.page_restrictions
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.pagelinks
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.protected_titles
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.querycache
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.querycache_info
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.querycachetwo
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.recentchanges
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.redirect
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.revision
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.revision_actor_temp
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.revision_comment_temp
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.searchindex                          OK
 +
wikieduonline.site_identifiers
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.site_stats
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.sites
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.slot_roles
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.slots
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.templatelinks
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.text
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.updatelog
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.uploadstash
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.user
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.user_former_groups
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.user_groups
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.user_newtalk
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.user_properties
 +
note    : The storage engine for the table doesn't support repair
 +
wikieduonline.watchlist
 +
note    : The storage engine for the table doesn't support repair
 +
</pre>
  
  
 
{{Mysqlcheck}}
 
{{Mysqlcheck}}

Latest revision as of 10:44, 2 October 2024

mysqlcheck --repair --all-databases
mysql.column_stats                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.global_priv                                  OK
mysql.gtid_slave_pos
note     : The storage engine for the table doesn't support repair
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.index_stats                                  OK
mysql.innodb_index_stats
note     : The storage engine for the table doesn't support repair
mysql.innodb_table_stats
note     : The storage engine for the table doesn't support repair
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.roles_mapping                                OK
mysql.servers                                      OK
mysql.table_stats                                  OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.transaction_registry
note     : The storage engine for the table doesn't support repair
wikieduonline.actor
note     : The storage engine for the table doesn't support repair
wikieduonline.archive
note     : The storage engine for the table doesn't support repair
wikieduonline.bot_passwords
note     : The storage engine for the table doesn't support repair
wikieduonline.category
note     : The storage engine for the table doesn't support repair
wikieduonline.categorylinks
note     : The storage engine for the table doesn't support repair
wikieduonline.change_tag
note     : The storage engine for the table doesn't support repair
wikieduonline.change_tag_def
note     : The storage engine for the table doesn't support repair
wikieduonline.comment
note     : The storage engine for the table doesn't support repair
wikieduonline.content
note     : The storage engine for the table doesn't support repair
wikieduonline.content_models
note     : The storage engine for the table doesn't support repair
wikieduonline.externallinks
note     : The storage engine for the table doesn't support repair
wikieduonline.filearchive
note     : The storage engine for the table doesn't support repair
wikieduonline.image
note     : The storage engine for the table doesn't support repair
wikieduonline.imagelinks
note     : The storage engine for the table doesn't support repair
wikieduonline.interwiki
note     : The storage engine for the table doesn't support repair
wikieduonline.ip_changes
note     : The storage engine for the table doesn't support repair
wikieduonline.ipblocks
note     : The storage engine for the table doesn't support repair
wikieduonline.ipblocks_restrictions
note     : The storage engine for the table doesn't support repair
wikieduonline.iwlinks
note     : The storage engine for the table doesn't support repair
wikieduonline.job
note     : The storage engine for the table doesn't support repair
wikieduonline.l10n_cache
note     : The storage engine for the table doesn't support repair
wikieduonline.langlinks
note     : The storage engine for the table doesn't support repair
wikieduonline.log_search
note     : The storage engine for the table doesn't support repair
wikieduonline.logging
note     : The storage engine for the table doesn't support repair
wikieduonline.module_deps
note     : The storage engine for the table doesn't support repair
wikieduonline.objectcache
note     : The storage engine for the table doesn't support repair
wikieduonline.oldimage
note     : The storage engine for the table doesn't support repair
wikieduonline.page
note     : The storage engine for the table doesn't support repair
wikieduonline.page_props
note     : The storage engine for the table doesn't support repair
wikieduonline.page_restrictions
note     : The storage engine for the table doesn't support repair
wikieduonline.pagelinks
note     : The storage engine for the table doesn't support repair
wikieduonline.protected_titles
note     : The storage engine for the table doesn't support repair
wikieduonline.querycache
note     : The storage engine for the table doesn't support repair
wikieduonline.querycache_info
note     : The storage engine for the table doesn't support repair
wikieduonline.querycachetwo
note     : The storage engine for the table doesn't support repair
wikieduonline.recentchanges
note     : The storage engine for the table doesn't support repair
wikieduonline.redirect
note     : The storage engine for the table doesn't support repair
wikieduonline.revision
note     : The storage engine for the table doesn't support repair
wikieduonline.revision_actor_temp
note     : The storage engine for the table doesn't support repair
wikieduonline.revision_comment_temp
note     : The storage engine for the table doesn't support repair
wikieduonline.searchindex                          OK
wikieduonline.site_identifiers
note     : The storage engine for the table doesn't support repair
wikieduonline.site_stats
note     : The storage engine for the table doesn't support repair
wikieduonline.sites
note     : The storage engine for the table doesn't support repair
wikieduonline.slot_roles
note     : The storage engine for the table doesn't support repair
wikieduonline.slots
note     : The storage engine for the table doesn't support repair
wikieduonline.templatelinks
note     : The storage engine for the table doesn't support repair
wikieduonline.text
note     : The storage engine for the table doesn't support repair
wikieduonline.updatelog
note     : The storage engine for the table doesn't support repair
wikieduonline.uploadstash
note     : The storage engine for the table doesn't support repair
wikieduonline.user
note     : The storage engine for the table doesn't support repair
wikieduonline.user_former_groups
note     : The storage engine for the table doesn't support repair
wikieduonline.user_groups
note     : The storage engine for the table doesn't support repair
wikieduonline.user_newtalk
note     : The storage engine for the table doesn't support repair
wikieduonline.user_properties
note     : The storage engine for the table doesn't support repair
wikieduonline.watchlist
note     : The storage engine for the table doesn't support repair


Mysqlcheck

Advertising: