不確定怎麼發生 Table 'performance_schema.session_variables' doesn't exist 的問題!

但因為造成無法匯入資料影響工作進度,所以爬文試圖解決!

找到 http://stackoverflow.com/questions/31967527/table-performance-schema-session-variables-doesnt-exist 這篇文章

經由強迫升級的方式, 將 mysql 本身的資料庫進行升級,就能解決問題!

為了確保不必要的困擾與萬一,建議在執行升級之前,就先把資料庫備份一份,以備不時之需.

於指定端輸入 mysql_upgrade -u root -p --force

將開始進行升級

Enter password:
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
mysql.column_stats                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.engine_cost                                  OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.gtid_executed                                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.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.roles_mapping                                OK
mysql.server_cost                                  OK
mysql.servers                                      OK
mysql.slave_master_info                            OK
mysql.slave_relay_log_info                         OK
mysql.slave_worker_info                            OK
mysql.slow_log                                     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
The sys schema is already up to date (version 1.5.1).
Checking databases.
baiyo.admin_menus                                  OK
baiyo.admin_password_resets                        OK
baiyo.admins                                       OK
baiyo.migrations                                   OK
baiyo.password_resets                              OK
baiyo.site_configs                                 OK
baiyo.user_password_resets                         OK
baiyo.users                                        OK
dryours.member_histories                           OK
dryours.members                                    OK
dryours.migrations                                 OK
dryours.order_items                                OK
dryours.order_mains                                OK
dryours.order_ships                                OK
dryours.order_tickets                              OK
dryours.password_resets                            OK
dryours.pd_categories                              OK
dryours.pd_products                                OK
dryours.users                                      OK
haifuwei.account_statuses                          OK
haifuwei.country_lists                             OK
haifuwei.member_levels                             OK
haifuwei.migrations                                OK
haifuwei.mt4accounts                               OK
haifuwei.password_resets                           OK
haifuwei.site__configs                             OK
haifuwei.teams                                     OK
haifuwei.user_menuses                              OK
haifuwei.users                                     OK
sctek_clinks.migrations                            OK
sctek_clinks.password_resets                       OK
sctek_clinks.site_configs                          OK
sctek_clinks.users                                 OK
sctek_worldtrenddb.migrations                      OK
sctek_worldtrenddb.password_resets                 OK
sctek_worldtrenddb.site__configs                   OK
sctek_worldtrenddb.user_menuses                    OK
sctek_worldtrenddb.users                           OK
sctek_worldtrenddb.waitnotifies                    OK
sys.sys_config                                     OK
Upgrade process completed successfully.
Checking if update is needed.
 

升級告一段落後,問題解決! 以上為心得,供參考,謝謝!

 


創作者介紹

經驗交流分享與備忘

Frank 發表在 痞客邦 PIXNET 留言(0) 人氣()