Rebuilding or Repairing database Mysql
Kadang-kadang tabel Anda crash dan website Anda tidak ada respon. Anda tidak dapat mengakses phpMyAdmin untuk melakukan perbaikan, inilah cara alternatif untuk membawa Situs Anda kembali akses Berikutnya saatnya untuk Rebuilding or Repairing database Mysql
|
1 2 3 |
mysqlcheck --all-databases -r #repair mysqlcheck --all-databases -a #analyze mysqlcheck --all-databases -o #optimize |
contoh repair databasee
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 |
[root@mail ~]# mysqlcheck -u root -p -A --auto-repair Enter password: demmyid.wp_commentmeta OK demmyid.wp_comments OK demmyid.wp_links OK demmyid.wp_options OK demmyid.wp_postmeta OK demmyid.wp_posts OK demmyid.wp_revslider_css OK demmyid.wp_revslider_layer_animations OK demmyid.wp_revslider_navigations OK demmyid.wp_revslider_settings OK demmyid.wp_revslider_sliders OK demmyid.wp_revslider_slides OK demmyid.wp_revslider_static_slides OK demmyid.wp_term_relationships OK demmyid.wp_term_taxonomy OK demmyid.wp_termmeta OK demmyid.wp_terms OK demmyid.wp_usermeta OK demmyid.wp_users OK mysql.column_stats OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.gtid_slave_pos OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.index_stats OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK mysql.max_used_connections note : The storage engine for the table doesn't support check 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.user OK |