{"id":9614,"date":"2022-11-17T00:44:51","date_gmt":"2022-11-17T00:44:51","guid":{"rendered":"https:\/\/stevepedwards.today\/DebianAdmin\/?p=9614"},"modified":"2022-11-25T00:21:16","modified_gmt":"2022-11-25T00:21:16","slug":"mysql-db-repair-commands","status":"publish","type":"post","link":"https:\/\/stevepedwards.today\/DebianAdmin\/mysql-db-repair-commands\/","title":{"rendered":"MYSQL DB Repair Commands"},"content":{"rendered":"<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9614\" class=\"pvc_stats all  \" data-element-id=\"9614\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/stevepedwards.today\/DebianAdmin\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n<p>Find DB collation:<br \/>\nSELECT @@character_set_database, @@collation_database;<\/p>\n<p>and for Engine:<br \/>\nSHOW TABLE STATUS\\G<\/p>\n<p>Diff Engines are not a prob in same DB.<\/p>\n<p>GRANT ALL PRIVILEGES ON ElectronicsStuff TO stevee@localhost IDENTIFIED BY pword ;<\/p>\n<p>SHOW GRANTS FOR 'stevee'@'localhost';<\/p>\n<p>systemctl restart mysql.service<\/p>\n<p>mysql&gt; CREATE USER 'root'@'%' IDENTIFIED BY 'PASSWORD';<br \/>\nmysql&gt; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;<br \/>\nmysql&gt; FLUSH PRIVILEGES;<\/p>\n<p>ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';<\/p>\n<p>mysql&gt; show tables ;<br \/>\n+----------------------------+<br \/>\n| Tables_in_ElectronicsStuff |<br \/>\n+----------------------------+<br \/>\n| wp_Counterize |<br \/>\n| wp_Counterize_Countries |<br \/>\n| wp_Counterize_Keywords |<br \/>\n| wp_Counterize_Outlinks |<br \/>\n| wp_Counterize_Pages |<br \/>\n| wp_Counterize_Referers |<br \/>\n| wp_Counterize_UserAgents |<br \/>\n| wp_commentmeta |<br \/>\n| wp_comments |<br \/>\n| wp_edd_customermeta |<br \/>\n| wp_edd_customers |<br \/>\n| wp_links |<br \/>\n| wp_options |<br \/>\n| wp_postmeta |<br \/>\n| wp_posts |<br \/>\n| wp_term_relationships |<br \/>\n| wp_term_taxonomy |<br \/>\n| wp_termmeta |<br \/>\n| wp_terms |<br \/>\n| wp_usermeta |<br \/>\n| wp_users |<br \/>\n| wp_xubg_commentmeta |<br \/>\n| wp_xubg_comments |<br \/>\n| wp_xubg_links |<br \/>\n| wp_xubg_options |<br \/>\n| wp_xubg_postmeta |<br \/>\n| wp_xubg_posts |<br \/>\n| wp_xubg_term_relationships |<br \/>\n| wp_xubg_term_taxonomy |<br \/>\n| wp_xubg_termmeta |<br \/>\n| wp_xubg_terms |<br \/>\n| wp_xubg_usermeta |<br \/>\n| wp_xubg_users |<br \/>\n| wpnt_commentmeta |<br \/>\n| wpnt_comments |<br \/>\n| wpnt_links |<br \/>\n| wpnt_options |<br \/>\n| wpnt_postmeta |<br \/>\n| wpnt_posts |<br \/>\n| wpnt_term_relationships |<br \/>\n| wpnt_term_taxonomy |<br \/>\n| wpnt_termmeta |<br \/>\n| wpnt_terms |<br \/>\n| wpnt_usermeta |<br \/>\n| wpnt_users |<br \/>\n| wpnt_wprss_logs |<br \/>\n+----------------------------+<\/p>\n<p>stevee@localhost:\/var\/www\/ElectronicsStuff$ mysqlcheck -c ElectronicsStuff -u stevee -p<br \/>\nEnter password:<br \/>\nElectronicsStuff.wp_Counterize OK<br \/>\nElectronicsStuff.wp_Counterize_Countries OK<br \/>\nElectronicsStuff.wp_Counterize_Keywords OK<br \/>\nElectronicsStuff.wp_Counterize_Outlinks OK<br \/>\nElectronicsStuff.wp_Counterize_Pages OK<br \/>\nElectronicsStuff.wp_Counterize_Referers OK<br \/>\nElectronicsStuff.wp_Counterize_UserAgents OK<br \/>\nElectronicsStuff.wp_commentmeta OK<br \/>\nElectronicsStuff.wp_comments OK<br \/>\nElectronicsStuff.wp_edd_customermeta OK<br \/>\nElectronicsStuff.wp_edd_customers OK<br \/>\nElectronicsStuff.wp_links OK<br \/>\nElectronicsStuff.wp_options OK<br \/>\nElectronicsStuff.wp_postmeta OK<br \/>\nElectronicsStuff.wp_posts OK<br \/>\nElectronicsStuff.wp_term_relationships OK<br \/>\nElectronicsStuff.wp_term_taxonomy OK<br \/>\nElectronicsStuff.wp_termmeta OK<br \/>\nElectronicsStuff.wp_terms OK<br \/>\nElectronicsStuff.wp_usermeta OK<br \/>\nElectronicsStuff.wp_users OK<br \/>\nElectronicsStuff.wp_xubg_commentmeta OK<br \/>\nElectronicsStuff.wp_xubg_comments OK<br \/>\nElectronicsStuff.wp_xubg_links OK<br \/>\nElectronicsStuff.wp_xubg_options OK<br \/>\nElectronicsStuff.wp_xubg_postmeta OK<br \/>\nElectronicsStuff.wp_xubg_posts OK<br \/>\nElectronicsStuff.wp_xubg_term_relationships OK<br \/>\nElectronicsStuff.wp_xubg_term_taxonomy OK<br \/>\nElectronicsStuff.wp_xubg_termmeta OK<br \/>\nElectronicsStuff.wp_xubg_terms OK<br \/>\nElectronicsStuff.wp_xubg_usermeta OK<br \/>\nElectronicsStuff.wp_xubg_users OK<br \/>\nElectronicsStuff.wpnt_commentmeta OK<br \/>\nElectronicsStuff.wpnt_comments OK<br \/>\nElectronicsStuff.wpnt_links OK<br \/>\nElectronicsStuff.wpnt_options OK<br \/>\nElectronicsStuff.wpnt_postmeta OK<br \/>\nElectronicsStuff.wpnt_posts OK<br \/>\nElectronicsStuff.wpnt_term_relationships OK<br \/>\nElectronicsStuff.wpnt_term_taxonomy OK<br \/>\nElectronicsStuff.wpnt_termmeta OK<br \/>\nElectronicsStuff.wpnt_terms OK<br \/>\nElectronicsStuff.wpnt_usermeta OK<br \/>\nElectronicsStuff.wpnt_users OK<br \/>\nElectronicsStuff.wpnt_wprss_logs OK<\/p>\n<p>stevee@localhost:\/var\/www\/ElectronicsStuff$ mysqlcheck -c -u stevee -p --all-databases<br \/>\nEnter password:<br \/>\nDebianAdmin.wp_xubg_commentmeta OK<br \/>\nDebianAdmin.wp_xubg_comments OK<br \/>\nDebianAdmin.wp_xubg_ewwwio_images OK<br \/>\nDebianAdmin.wp_xubg_ewwwio_queue OK<br \/>\nDebianAdmin.wp_xubg_links OK<br \/>\nDebianAdmin.wp_xubg_options OK<br \/>\nDebianAdmin.wp_xubg_postmeta OK<br \/>\nDebianAdmin.wp_xubg_posts OK<br \/>\nDebianAdmin.wp_xubg_pvc_daily OK<br \/>\nDebianAdmin.wp_xubg_pvc_total OK<br \/>\nDebianAdmin.wp_xubg_snippets OK<br \/>\nDebianAdmin.wp_xubg_term_relationships OK<br \/>\nDebianAdmin.wp_xubg_term_taxonomy OK<br \/>\nDebianAdmin.wp_xubg_termmeta OK<br \/>\nDebianAdmin.wp_xubg_terms OK<br \/>\nDebianAdmin.wp_xubg_usermeta OK<br \/>\nDebianAdmin.wp_xubg_users OK<br \/>\nElectronicsStuff.wp_Counterize OK<br \/>\nElectronicsStuff.wp_Counterize_Countries OK<br \/>\nElectronicsStuff.wp_Counterize_Keywords OK<br \/>\nElectronicsStuff.wp_Counterize_Outlinks OK<br \/>\nElectronicsStuff.wp_Counterize_Pages OK<br \/>\nElectronicsStuff.wp_Counterize_Referers OK<br \/>\nElectronicsStuff.wp_Counterize_UserAgents OK<br \/>\nElectronicsStuff.wp_commentmeta OK<br \/>\nElectronicsStuff.wp_comments OK<br \/>\nElectronicsStuff.wp_edd_customermeta OK<br \/>\nElectronicsStuff.wp_edd_customers OK<br \/>\nElectronicsStuff.wp_links OK<br \/>\nElectronicsStuff.wp_options OK<br \/>\nElectronicsStuff.wp_postmeta OK<br \/>\nElectronicsStuff.wp_posts OK<br \/>\nElectronicsStuff.wp_term_relationships OK<br \/>\nElectronicsStuff.wp_term_taxonomy OK<br \/>\nElectronicsStuff.wp_termmeta OK<br \/>\nElectronicsStuff.wp_terms OK<br \/>\nElectronicsStuff.wp_usermeta OK<br \/>\nElectronicsStuff.wp_users OK<br \/>\nElectronicsStuff.wp_xubg_commentmeta OK<br \/>\nElectronicsStuff.wp_xubg_comments OK<br \/>\nElectronicsStuff.wp_xubg_links OK<br \/>\nElectronicsStuff.wp_xubg_options OK<br \/>\nElectronicsStuff.wp_xubg_postmeta OK<br \/>\nElectronicsStuff.wp_xubg_posts OK<br \/>\nElectronicsStuff.wp_xubg_term_relationships OK<br \/>\nElectronicsStuff.wp_xubg_term_taxonomy OK<br \/>\nElectronicsStuff.wp_xubg_termmeta OK<br \/>\nElectronicsStuff.wp_xubg_terms OK<br \/>\nElectronicsStuff.wp_xubg_usermeta OK<br \/>\nElectronicsStuff.wp_xubg_users OK<br \/>\nElectronicsStuff.wpnt_commentmeta OK<br \/>\nElectronicsStuff.wpnt_comments OK<br \/>\nElectronicsStuff.wpnt_links OK<br \/>\nElectronicsStuff.wpnt_options OK<br \/>\nElectronicsStuff.wpnt_postmeta OK<br \/>\nElectronicsStuff.wpnt_posts OK<br \/>\nElectronicsStuff.wpnt_term_relationships OK<br \/>\nElectronicsStuff.wpnt_term_taxonomy OK<br \/>\nElectronicsStuff.wpnt_termmeta OK<br \/>\nElectronicsStuff.wpnt_terms OK<br \/>\nElectronicsStuff.wpnt_usermeta OK<br \/>\nElectronicsStuff.wpnt_users OK<br \/>\nElectronicsStuff.wpnt_wprss_logs OK<br \/>\nmyphpsite.text OK<br \/>\nmysql.columns_priv OK<br \/>\nmysql.component OK<br \/>\nmysql.db OK<br \/>\nmysql.default_roles OK<br \/>\nmysql.engine_cost OK<br \/>\nmysql.func OK<br \/>\nmysql.general_log OK<br \/>\nmysql.global_grants OK<br \/>\nmysql.gtid_executed OK<br \/>\nmysql.help_category OK<br \/>\nmysql.help_keyword OK<br \/>\nmysql.help_relation OK<br \/>\nmysql.help_topic OK<br \/>\nmysql.innodb_index_stats OK<br \/>\nmysql.innodb_table_stats OK<br \/>\nmysql.password_history OK<br \/>\nmysql.plugin OK<br \/>\nmysql.procs_priv OK<br \/>\nmysql.proxies_priv OK<br \/>\nmysql.replication_asynchronous_connection_failover OK<br \/>\nmysql.replication_asynchronous_connection_failover_managed OK<br \/>\nmysql.replication_group_configuration_version OK<br \/>\nmysql.replication_group_member_actions OK<br \/>\nmysql.role_edges OK<br \/>\nmysql.server_cost OK<br \/>\nmysql.servers OK<br \/>\nmysql.slave_master_info OK<br \/>\nmysql.slave_relay_log_info OK<br \/>\nmysql.slave_worker_info OK<br \/>\nmysql.slow_log OK<br \/>\nmysql.tables_priv OK<br \/>\nmysql.time_zone OK<br \/>\nmysql.time_zone_leap_second OK<br \/>\nmysql.time_zone_name OK<br \/>\nmysql.time_zone_transition OK<br \/>\nmysql.time_zone_transition_type OK<br \/>\nmysql.user OK<br \/>\nphpmyadmin.pma__bookmark OK<br \/>\nphpmyadmin.pma__central_columns OK<br \/>\nphpmyadmin.pma__column_info OK<br \/>\nphpmyadmin.pma__designer_settings OK<br \/>\nphpmyadmin.pma__export_templates OK<br \/>\nphpmyadmin.pma__favorite OK<br \/>\nphpmyadmin.pma__history OK<br \/>\nphpmyadmin.pma__navigationhiding OK<br \/>\nphpmyadmin.pma__pdf_pages OK<br \/>\nphpmyadmin.pma__recent OK<br \/>\nphpmyadmin.pma__relation OK<br \/>\nphpmyadmin.pma__savedsearches OK<br \/>\nphpmyadmin.pma__table_coords OK<br \/>\nphpmyadmin.pma__table_info OK<br \/>\nphpmyadmin.pma__table_uiprefs OK<br \/>\nphpmyadmin.pma__tracking OK<br \/>\nphpmyadmin.pma__userconfig OK<br \/>\nphpmyadmin.pma__usergroups OK<br \/>\nphpmyadmin.pma__users OK<br \/>\nsys.sys_config OK<br \/>\ntext.sometext<\/p>\n<p>stevee@localhost:\/var\/www\/ElectronicsStuff$ mysqlcheck -a ElectronicsStuff -u stevee -p<br \/>\nEnter password:<br \/>\nElectronicsStuff.wp_Counterize Table is already up to date<br \/>\nElectronicsStuff.wp_Counterize_Countries Table is already up to date<br \/>\nElectronicsStuff.wp_Counterize_Keywords Table is already up to date<br \/>\nElectronicsStuff.wp_Counterize_Outlinks Table is already up to date<br \/>\nElectronicsStuff.wp_Counterize_Pages Table is already up to date<br \/>\nElectronicsStuff.wp_Counterize_Referers Table is already up to date<br \/>\nElectronicsStuff.wp_Counterize_UserAgents Table is already up to date<br \/>\nElectronicsStuff.wp_commentmeta Table is already up to date<br \/>\nElectronicsStuff.wp_comments Table is already up to date<br \/>\nElectronicsStuff.wp_edd_customermeta Table is already up to date<br \/>\nElectronicsStuff.wp_edd_customers Table is already up to date<br \/>\nElectronicsStuff.wp_links Table is already up to date<br \/>\nElectronicsStuff.wp_options Table is already up to date<br \/>\nElectronicsStuff.wp_postmeta Table is already up to date<br \/>\nElectronicsStuff.wp_posts Table is already up to date<br \/>\nElectronicsStuff.wp_term_relationships Table is already up to date<br \/>\nElectronicsStuff.wp_term_taxonomy Table is already up to date<br \/>\nElectronicsStuff.wp_termmeta Table is already up to date<br \/>\nElectronicsStuff.wp_terms Table is already up to date<br \/>\nElectronicsStuff.wp_usermeta Table is already up to date<br \/>\nElectronicsStuff.wp_users Table is already up to date<br \/>\nElectronicsStuff.wp_xubg_commentmeta OK<br \/>\nElectronicsStuff.wp_xubg_comments OK<br \/>\nElectronicsStuff.wp_xubg_links OK<br \/>\nElectronicsStuff.wp_xubg_options OK<br \/>\nElectronicsStuff.wp_xubg_postmeta OK<br \/>\nElectronicsStuff.wp_xubg_posts OK<br \/>\nElectronicsStuff.wp_xubg_term_relationships OK<br \/>\nElectronicsStuff.wp_xubg_term_taxonomy OK<br \/>\nElectronicsStuff.wp_xubg_termmeta OK<br \/>\nElectronicsStuff.wp_xubg_terms OK<br \/>\nElectronicsStuff.wp_xubg_usermeta OK<br \/>\nElectronicsStuff.wp_xubg_users OK<br \/>\nElectronicsStuff.wpnt_commentmeta Table is already up to date<br \/>\nElectronicsStuff.wpnt_comments Table is already up to date<br \/>\nElectronicsStuff.wpnt_links Table is already up to date<br \/>\nElectronicsStuff.wpnt_options Table is already up to date<br \/>\nElectronicsStuff.wpnt_postmeta Table is already up to date<br \/>\nElectronicsStuff.wpnt_posts Table is already up to date<br \/>\nElectronicsStuff.wpnt_term_relationships Table is already up to date<br \/>\nElectronicsStuff.wpnt_term_taxonomy Table is already up to date<br \/>\nElectronicsStuff.wpnt_termmeta Table is already up to date<br \/>\nElectronicsStuff.wpnt_terms Table is already up to date<br \/>\nElectronicsStuff.wpnt_usermeta Table is already up to date<br \/>\nElectronicsStuff.wpnt_users Table is already up to date<br \/>\nElectronicsStuff.wpnt_wprss_logs Table is already up to date<\/p>\n<p>OPTIMISE - shows FAULT:<br \/>\nstevee@localhost:\/var\/www\/ElectronicsStuff$ mysqlcheck -o ElectronicsStuff -u stevee -p<br \/>\nEnter password:<br \/>\nElectronicsStuff.wp_Counterize OK<br \/>\nElectronicsStuff.wp_Counterize_Countries OK<br \/>\nElectronicsStuff.wp_Counterize_Keywords OK<br \/>\nElectronicsStuff.wp_Counterize_Outlinks OK<br \/>\nElectronicsStuff.wp_Counterize_Pages OK<br \/>\nElectronicsStuff.wp_Counterize_Referers OK<br \/>\nElectronicsStuff.wp_Counterize_UserAgents OK<br \/>\nElectronicsStuff.wp_commentmeta OK<br \/>\nElectronicsStuff.wp_comments OK<br \/>\nElectronicsStuff.wp_edd_customermeta OK<br \/>\nElectronicsStuff.wp_edd_customers OK<br \/>\nElectronicsStuff.wp_links OK<br \/>\nElectronicsStuff.wp_options OK<br \/>\nElectronicsStuff.wp_postmeta OK<br \/>\nElectronicsStuff.wp_posts OK<br \/>\nElectronicsStuff.wp_term_relationships OK<br \/>\nElectronicsStuff.wp_term_taxonomy OK<br \/>\nElectronicsStuff.wp_termmeta OK<br \/>\nElectronicsStuff.wp_terms OK<br \/>\nElectronicsStuff.wp_usermeta OK<br \/>\nElectronicsStuff.wp_users OK<br \/>\nElectronicsStuff.wp_xubg_commentmeta<br \/>\nnote : Table does not support optimize, doing recreate + analyze instead<br \/>\nstatus : OK<br \/>\nElectronicsStuff.wp_xubg_comments<br \/>\nnote : Table does not support optimize, doing recreate + analyze instead<br \/>\n<span style=\"color: #ff0000;\">error : Invalid default value for 'comment_date'<\/span><br \/>\nstatus : Operation failed<br \/>\nElectronicsStuff.wp_xubg_links<br \/>\nnote : Table does not support optimize, doing recreate + analyze instead<br \/>\n<span style=\"color: #ff0000;\">error : Invalid default value for 'link_updated'<\/span><br \/>\nstatus : Operation failed<br \/>\nElectronicsStuff.wp_xubg_options<br \/>\nnote : Table does not support optimize, doing recreate + analyze instead<br \/>\nstatus : OK<br \/>\nElectronicsStuff.wp_xubg_postmeta<br \/>\nnote : Table does not support optimize, doing recreate + analyze instead<br \/>\nstatus : OK<br \/>\nElectronicsStuff.wp_xubg_posts<br \/>\nnote : Table does not support optimize, doing recreate + analyze instead<br \/>\n<span style=\"color: #ff0000;\">error : Invalid default value for 'post_date'<\/span><br \/>\nstatus : Operation failed<br \/>\nElectronicsStuff.wp_xubg_term_relationships<br \/>\nnote : Table does not support optimize, doing recreate + analyze instead<br \/>\nstatus : OK<\/p>\n<p>REPAIR:<\/p>\n<p>stevee@localhost:\/var\/www\/ElectronicsStuff$ mysqlcheck -r ElectronicsStuff -u stevee -p<br \/>\nEnter password:<br \/>\nElectronicsStuff.wp_Counterize OK<br \/>\nElectronicsStuff.wp_Counterize_Countries OK<br \/>\nElectronicsStuff.wp_Counterize_Keywords OK<br \/>\nElectronicsStuff.wp_Counterize_Outlinks OK<br \/>\nElectronicsStuff.wp_Counterize_Pages OK<br \/>\nElectronicsStuff.wp_Counterize_Referers OK<br \/>\nElectronicsStuff.wp_Counterize_UserAgents OK<br \/>\nElectronicsStuff.wp_commentmeta OK<br \/>\nElectronicsStuff.wp_comments OK<br \/>\nElectronicsStuff.wp_edd_customermeta OK<br \/>\nElectronicsStuff.wp_edd_customers OK<br \/>\nElectronicsStuff.wp_links OK<br \/>\nElectronicsStuff.wp_options OK<br \/>\nElectronicsStuff.wp_postmeta OK<br \/>\nElectronicsStuff.wp_posts OK<br \/>\nElectronicsStuff.wp_term_relationships OK<br \/>\nElectronicsStuff.wp_term_taxonomy OK<br \/>\nElectronicsStuff.wp_termmeta OK<br \/>\nElectronicsStuff.wp_terms OK<br \/>\nElectronicsStuff.wp_usermeta OK<br \/>\nElectronicsStuff.wp_users OK<br \/>\nElectronicsStuff.wp_xubg_commentmeta<br \/>\nnote : The storage engine for the table doesn't support repair<br \/>\nElectronicsStuff.wp_xubg_comments<br \/>\nnote : The storage engine for the table doesn't support repair<br \/>\nElectronicsStuff.wp_xubg_links<br \/>\nnote : The storage engine for the table doesn't support repair<br \/>\nElectronicsStuff.wp_xubg_options<br \/>\nnote : The storage engine for the table doesn't support repair<br \/>\nElectronicsStuff.wp_xubg_postmeta<br \/>\nnote : The storage engine for the table doesn't support repair<br \/>\nElectronicsStuff.wp_xubg_posts<br \/>\nnote : The storage engine for the table doesn't support repair<br \/>\nElectronicsStuff.wp_xubg_term_relationships<br \/>\nnote : The storage engine for the table doesn't support repair<br \/>\nElectronicsStuff.wp_xubg_term_taxonomy<br \/>\nnote : The storage engine for the table doesn't support repair<br \/>\nElectronicsStuff.wp_xubg_termmeta<br \/>\nnote : The storage engine for the table doesn't support repair<br \/>\nElectronicsStuff.wp_xubg_terms<br \/>\nnote : The storage engine for the table doesn't support repair<br \/>\nElectronicsStuff.wp_xubg_usermeta<br \/>\nnote : The storage engine for the table doesn't support repair<br \/>\nElectronicsStuff.wp_xubg_users<br \/>\nnote : The storage engine for the table doesn't support repair<br \/>\nElectronicsStuff.wpnt_commentmeta OK<br \/>\nElectronicsStuff.wpnt_comments OK<br \/>\nElectronicsStuff.wpnt_links OK<br \/>\nElectronicsStuff.wpnt_options OK<br \/>\nElectronicsStuff.wpnt_postmeta OK<br \/>\nElectronicsStuff.wpnt_posts OK<br \/>\nElectronicsStuff.wpnt_term_relationships OK<br \/>\nElectronicsStuff.wpnt_term_taxonomy OK<br \/>\nElectronicsStuff.wpnt_termmeta OK<br \/>\nElectronicsStuff.wpnt_terms OK<br \/>\nElectronicsStuff.wpnt_usermeta OK<br \/>\nElectronicsStuff.wpnt_users OK<br \/>\nElectronicsStuff.wpnt_wprss_logs OK<\/p>\n<p>ALL switches:<\/p>\n<p>-A, \u2013all-databases Consider all the databases<br \/>\n-a, \u2013analyze Analyze tables<br \/>\n-1, \u2013all-in-1 Use one query per database with tables listed in a comma separated way<br \/>\n\u2013auto-repair Repair the table automatically it if is corrupted<br \/>\n-c, \u2013check Check table errors<br \/>\n-C, \u2013check-only-changed Check tables that are changed since last check<br \/>\n-g, \u2013check-upgrade Check for version dependent changes in the tables<br \/>\n-B, \u2013databases Check more than one databases<br \/>\n-F, \u2013fast Check tables that are not closed properly<br \/>\n\u2013fix-db-names Fix DB names<br \/>\n\u2013fix-table-names Fix table names<br \/>\n-f, \u2013force Continue even when there is an error<br \/>\n-e, \u2013extended Perform extended check on a table. This will take a long time to execute.<br \/>\n-m, \u2013medium-check Faster than extended check option, but does most checks<br \/>\n-o, \u2013optimize Optimize tables<br \/>\n-q, \u2013quick Faster than medium check option<br \/>\n-r, \u2013repair Fix the table corruption<\/p>\n<p>mysql&gt; SELECT @@character_set_database, @@collation_database;<br \/>\n+--------------------------+----------------------+<br \/>\n| @@character_set_database | @@collation_database |<br \/>\n+--------------------------+----------------------+<br \/>\n| utf8mb4 | utf8mb4_0900_ai_ci<\/p>\n<p>Missing comma before start of a new alter operation. (near \"DEFAULT CHARSET\" at position 47)<\/p>\n<p>OK, let\u2019s try this. When displaying the database in phpMyAdmin, you will see a list of tables. One of them is wp_posts. Click on that table, and then click on the \u201cOperations\u201d tab. In the Table Options box, make sure the collation is set to utf8mb4_unicode_520_ci and there is a check in the \u201cChange all column collations\u201d checkbox, then click the \u201cGo\u201d button.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9614\" class=\"pvc_stats all  \" data-element-id=\"9614\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/stevepedwards.today\/DebianAdmin\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n<p>Find DB collation: SELECT @@character_set_database, @@collation_database; and for Engine: SHOW TABLE STATUS\\G Diff Engines are not a prob in same DB. GRANT ALL PRIVILEGES ON ElectronicsStuff TO stevee@localhost IDENTIFIED BY pword ; SHOW GRANTS FOR 'stevee'@'localhost'; systemctl restart mysql.service mysql&gt; CREATE USER 'root'@'%' IDENTIFIED BY 'PASSWORD'; mysql&gt; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH <a href=\"https:\/\/stevepedwards.today\/DebianAdmin\/mysql-db-repair-commands\/\" class=\"more-link\">...<span class=\"screen-reader-text\">\u00a0 MYSQL DB Repair Commands<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-9614","post","type-post","status-publish","format-standard","hentry","category-post"],"a3_pvc":{"activated":true,"total_views":22,"today_views":0},"_links":{"self":[{"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/posts\/9614","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/comments?post=9614"}],"version-history":[{"count":2,"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/posts\/9614\/revisions"}],"predecessor-version":[{"id":9694,"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/posts\/9614\/revisions\/9694"}],"wp:attachment":[{"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/media?parent=9614"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/categories?post=9614"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/tags?post=9614"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}