Re: databases are lost
Posted by:
jm L
Date: March 17, 2021 07:17AM
Hi,Peter!
Yes,I've deleted performance_schema dir and execute 'mysql_upgrade' command success.Is there an error in my upgrade steps,without execute 'mysql_upgrade' command.
mysql_upgrade result:
Enter password:
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
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.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic 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.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.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
Found outdated sys schema version 1.5.1.
Upgrading the sys schema.
Checking databases.
account_platform.bcg_msg OK
account_platform.bcg_msgservice OK
account_platform.bcg_msgtype OK
account_platform.bcg_trigger OK
account_platform.tb_account_apply_info OK
account_platform.tb_client_auth OK
account_platform.tb_client_cert OK
account_platform.tb_client_heartbeat OK
account_platform.tb_heartbeat OK
account_platform.tb_params OK
card_first.tb_batch_issue_apply OK
card_first.tb_card_first_detail_2019 OK
card_first.tb_card_first_detail_2020 OK
card_first.tb_card_first_detail_2021 OK
card_first.tb_card_first_detail_2022 OK
card_first.tb_card_first_detail_2023 OK
card_first.tb_card_first_detail_2024 OK
card_first.tb_card_first_detail_2025 OK
card_first.tb_card_first_record_2019 OK
card_first.tb_card_first_record_2020 OK
card_first.tb_card_first_record_2021 OK
card_first.tb_card_first_record_2022 OK
card_first.tb_card_first_record_2023 OK
card_first.tb_card_first_record_2024 OK
card_first.tb_card_first_record_2025 OK
card_first.tb_card_first_record_2026 OK
card_first.tb_card_first_record_count OK
card_first.tb_number_rule OK
card_first.tb_restore_rule OK
card_load.tb_card_load_record_2019 OK
card_load.tb_card_load_record_2020 OK
card_load.tb_card_load_record_2021 OK
card_load.tb_card_load_record_2022 OK
card_load.tb_card_load_record_2023 OK
card_load.tb_card_load_record_2024 OK
card_load.tb_card_load_record_2025 OK
card_load.tb_card_load_record_count OK
card_purchase.tb_card_purchase_record_1101_2020 OK
card_purchase.tb_card_purchase_record_1101_2021 OK
card_purchase.tb_card_purchase_record_1101_2022 OK
card_purchase.tb_card_purchase_record_1101_2023 OK
card_purchase.tb_card_purchase_record_1101_2024 OK
card_purchase.tb_card_purchase_record_1101_2025 OK
card_purchase.tb_card_purchase_record_1201_2020 OK
card_purchase.tb_card_purchase_record_1201_2021 OK
card_purchase.tb_card_purchase_record_1201_2022 OK
card_purchase.tb_card_purchase_record_1201_2023 OK
card_purchase.tb_card_purchase_record_1201_2024 OK
card_purchase.tb_card_purchase_record_1201_2025 OK
card_purchase.tb_card_purchase_record_1301_2020 OK
card_purchase.tb_card_purchase_record_1301_2021 OK
card_purchase.tb_card_purchase_record_1301_2022 OK
card_purchase.tb_card_purchase_record_1301_2023 OK
card_purchase.tb_card_purchase_record_1301_2024 OK
card_purchase.tb_card_purchase_record_1301_2025 OK
card_purchase.tb_card_purchase_record_1401_2020 OK
card_purchase.tb_card_purchase_record_1401_2021 OK
card_purchase.tb_card_purchase_record_1401_2022 OK
card_purchase.tb_card_purchase_record_1401_2023 OK
card_purchase.tb_card_purchase_record_1401_2024 OK
card_purchase.tb_card_purchase_record_1401_2025 OK
card_purchase.tb_card_purchase_record_1501_2020 OK
card_purchase.tb_card_purchase_record_1501_2021 OK
card_purchase.tb_card_purchase_record_1501_2022 OK
card_purchase.tb_card_purchase_record_1501_2023 OK
card_purchase.tb_card_purchase_record_1501_2024 OK
card_purchase.tb_card_purchase_record_1501_2025 OK
card_purchase.tb_card_purchase_record_2101_2020 OK
card_purchase.tb_card_purchase_record_2101_2021 OK
card_purchase.tb_card_purchase_record_2101_2022 OK
card_purchase.tb_card_purchase_record_2101_2023 OK
card_purchase.tb_card_purchase_record_2101_2024 OK
card_purchase.tb_card_purchase_record_2101_2025 OK
card_purchase.tb_card_purchase_record_2201_2020 OK
card_purchase.tb_card_purchase_record_2201_2021 OK
card_purchase.tb_card_purchase_record_2201_2022 OK
card_purchase.tb_card_purchase_record_2201_2023 OK
card_purchase.tb_card_purchase_record_2201_2024 OK
card_purchase.tb_card_purchase_record_2201_2025 OK
card_purchase.tb_card_purchase_record_2301_2020 OK
card_purchase.tb_card_purchase_record_2301_2021 OK
card_purchase.tb_card_purchase_record_2301_2022 OK
card_purchase.tb_card_purchase_record_2301_2023 OK
card_purchase.tb_card_purchase_record_2301_2024 OK
card_purchase.tb_card_purchase_record_2301_2025 OK
card_purchase.tb_card_purchase_record_3101_2020 OK
card_purchase.tb_card_purchase_record_3101_2021 OK
card_purchase.tb_card_purchase_record_3101_2022 OK
card_purchase.tb_card_purchase_record_3101_2023 OK
card_purchase.tb_card_purchase_record_3101_2024 OK
card_purchase.tb_card_purchase_record_3101_2025 OK
card_purchase.tb_card_purchase_record_3201_2020 OK
card_purchase.tb_card_purchase_record_3201_2021 OK
card_purchase.tb_card_purchase_record_3201_2022 OK
card_purchase.tb_card_purchase_record_3201_2023 OK
card_purchase.tb_card_purchase_record_3201_2024 OK
card_purchase.tb_card_purchase_record_3201_2025 OK
card_purchase.tb_card_purchase_record_3301_2020 OK
card_purchase.tb_card_purchase_record_3301_2021 OK
card_purchase.tb_card_purchase_record_3301_2022 OK
card_purchase.tb_card_purchase_record_3301_2023 OK
card_purchase.tb_card_purchase_record_3301_2024 OK
card_purchase.tb_card_purchase_record_3301_2025 OK
card_purchase.tb_card_purchase_record_3401_2020 OK
card_purchase.tb_card_purchase_record_3401_2021 OK
card_purchase.tb_card_purchase_record_3401_2022 OK
card_purchase.tb_card_purchase_record_3401_2023 OK
card_purchase.tb_card_purchase_record_3401_2024 OK
card_purchase.tb_card_purchase_record_3401_2025 OK
card_purchase.tb_card_purchase_record_3501_2020 OK
card_purchase.tb_card_purchase_record_3501_2021 OK
card_purchase.tb_card_purchase_record_3501_2022 OK
card_purchase.tb_card_purchase_record_3501_2023 OK
card_purchase.tb_card_purchase_record_3501_2024 OK
card_purchase.tb_card_purchase_record_3501_2025 OK
card_purchase.tb_card_purchase_record_3601_2020 OK
card_purchase.tb_card_purchase_record_3601_2021 OK
card_purchase.tb_card_purchase_record_3601_2022 OK
card_purchase.tb_card_purchase_record_3601_2023 OK
card_purchase.tb_card_purchase_record_3601_2024 OK
card_purchase.tb_card_purchase_record_3601_2025 OK
card_purchase.tb_card_purchase_record_3701_2020 OK
card_purchase.tb_card_purchase_record_3701_2021 OK
card_purchase.tb_card_purchase_record_3701_2022 OK
card_purchase.tb_card_purchase_record_3701_2023 OK
card_purchase.tb_card_purchase_record_3701_2024 OK
card_purchase.tb_card_purchase_record_3701_2025 OK
card_purchase.tb_card_purchase_record_4101_2020 OK
card_purchase.tb_card_purchase_record_4101_2021 OK
card_purchase.tb_card_purchase_record_4101_2022 OK
card_purchase.tb_card_purchase_record_4101_2023 OK
card_purchase.tb_card_purchase_record_4101_2024 OK
card_purchase.tb_card_purchase_record_4101_2025 OK
card_purchase.tb_card_purchase_record_4201_2020 OK
card_purchase.tb_card_purchase_record_4201_2021 OK
card_purchase.tb_card_purchase_record_4201_2022 OK
card_purchase.tb_card_purchase_record_4201_2023 OK
card_purchase.tb_card_purchase_record_4201_2024 OK
card_purchase.tb_card_purchase_record_4201_2025 OK
card_purchase.tb_card_purchase_record_4301_2020 OK
card_purchase.tb_card_purchase_record_4301_2021 OK
card_purchase.tb_card_purchase_record_4301_2022 OK
card_purchase.tb_card_purchase_record_4301_2023 OK
card_purchase.tb_card_purchase_record_4301_2024 OK
card_purchase.tb_card_purchase_record_4301_2025 OK
card_purchase.tb_card_purchase_record_4401_2020 OK
card_purchase.tb_card_purchase_record_4401_2021 OK
card_purchase.tb_card_purchase_record_4401_2022 OK
card_purchase.tb_card_purchase_record_4401_2023 OK
card_purchase.tb_card_purchase_record_4401_2024 OK
card_purchase.tb_card_purchase_record_4401_2025 OK
card_purchase.tb_card_purchase_record_4501_2020 OK
card_purchase.tb_card_purchase_record_4501_2021 OK
card_purchase.tb_card_purchase_record_4501_2022 OK
card_purchase.tb_card_purchase_record_4501_2023 OK
card_purchase.tb_card_purchase_record_4501_2024 OK
card_purchase.tb_card_purchase_record_4501_2025 OK
card_purchase.tb_card_purchase_record_4601_2020 OK
card_purchase.tb_card_purchase_record_4601_2021 OK
card_purchase.tb_card_purchase_record_4601_2022 OK
card_purchase.tb_card_purchase_record_4601_2023 OK
card_purchase.tb_card_purchase_record_4601_2024 OK
card_purchase.tb_card_purchase_record_4601_2025 OK
card_purchase.tb_card_purchase_record_5001_2020 OK
card_purchase.tb_card_purchase_record_5001_2021 OK
card_purchase.tb_card_purchase_record_5001_2022 OK
card_purchase.tb_card_purchase_record_5001_2023 OK
card_purchase.tb_card_purchase_record_5001_2024 OK
card_purchase.tb_card_purchase_record_5001_2025 OK
card_purchase.tb_card_purchase_record_5101_2020 OK
card_purchase.tb_card_purchase_record_5101_2021 OK
card_purchase.tb_card_purchase_record_5101_2022 OK
card_purchase.tb_card_purchase_record_5101_2023 OK
card_purchase.tb_card_purchase_record_5101_2024 OK
card_purchase.tb_card_purchase_record_5101_2025 OK
card_purchase.tb_card_purchase_record_5201_2020 OK
card_purchase.tb_card_purchase_record_5201_2021 OK
card_purchase.tb_card_purchase_record_5201_2022 OK
card_purchase.tb_card_purchase_record_5201_2023 OK
card_purchase.tb_card_purchase_record_5201_2024 OK
card_purchase.tb_card_purchase_record_5201_2025 OK
card_purchase.tb_card_purchase_record_5301_2020 OK
card_purchase.tb_card_purchase_record_5301_2021 OK
card_purchase.tb_card_purchase_record_5301_2022 OK
card_purchase.tb_card_purchase_record_5301_2023 OK
card_purchase.tb_card_purchase_record_5301_2024 OK
card_purchase.tb_card_purchase_record_5301_2025 OK
card_purchase.tb_card_purchase_record_5401_2020 OK
card_purchase.tb_card_purchase_record_5401_2021 OK
card_purchase.tb_card_purchase_record_5401_2022 OK
card_purchase.tb_card_purchase_record_5401_2023 OK
card_purchase.tb_card_purchase_record_5401_2024 OK
card_purchase.tb_card_purchase_record_5401_2025 OK
card_purchase.tb_card_purchase_record_6101_2020 OK
card_purchase.tb_card_purchase_record_6101_2021 OK
card_purchase.tb_card_purchase_record_6101_2022 OK
card_purchase.tb_card_purchase_record_6101_2023 OK
card_purchase.tb_card_purchase_record_6101_2024 OK
card_purchase.tb_card_purchase_record_6101_2025 OK
card_purchase.tb_card_purchase_record_6201_2020 OK
card_purchase.tb_card_purchase_record_6201_2021 OK
card_purchase.tb_card_purchase_record_6201_2022 OK
card_purchase.tb_card_purchase_record_6201_2023 OK
card_purchase.tb_card_purchase_record_6201_2024 OK
card_purchase.tb_card_purchase_record_6201_2025 OK
card_purchase.tb_card_purchase_record_6301_2020 OK
card_purchase.tb_card_purchase_record_6301_2021 OK
card_purchase.tb_card_purchase_record_6301_2022 OK
card_purchase.tb_card_purchase_record_6301_2023 OK
card_purchase.tb_card_purchase_record_6301_2024 OK
card_purchase.tb_card_purchase_record_6301_2025 OK
card_purchase.tb_card_purchase_record_6401_2020 OK
card_purchase.tb_card_purchase_record_6401_2021 OK
card_purchase.tb_card_purchase_record_6401_2022 OK
card_purchase.tb_card_purchase_record_6401_2023 OK
card_purchase.tb_card_purchase_record_6401_2024 OK
card_purchase.tb_card_purchase_record_6401_2025 OK
card_purchase.tb_card_purchase_record_6501_2020 OK
card_purchase.tb_card_purchase_record_6501_2021 OK
card_purchase.tb_card_purchase_record_6501_2022 OK
card_purchase.tb_card_purchase_record_6501_2023 OK
card_purchase.tb_card_purchase_record_6501_2024 OK
card_purchase.tb_card_purchase_record_6501_2025 OK
card_purchase.tb_card_purchase_record_9901_2020 OK
card_purchase.tb_card_purchase_record_9901_2021 OK
card_purchase.tb_card_purchase_record_9901_2022 OK
card_purchase.tb_card_purchase_record_9901_2023 OK
card_purchase.tb_card_purchase_record_9901_2024 OK
card_purchase.tb_card_purchase_record_9901_2025 OK
card_purchase.tb_card_purchase_record_count OK
card_purchase.tb_terminal OK
card_second.tb_area_no OK
card_second.tb_card_second_detail_2019 OK
card_second.tb_card_second_detail_2020 OK
card_second.tb_card_second_detail_2021 OK
card_second.tb_card_second_detail_2022 OK
card_second.tb_card_second_detail_2023 OK
card_second.tb_card_second_detail_2024 OK
card_second.tb_card_second_detail_2025 OK
card_second.tb_card_second_record_2019 OK
card_second.tb_card_second_record_2020 OK
card_second.tb_card_second_record_2021 OK
card_second.tb_card_second_record_2022 OK
card_second.tb_card_second_record_2023 OK
card_second.tb_card_second_record_2024 OK
card_second.tb_card_second_record_2025 OK
card_second.tb_card_second_record_count OK
card_second.tb_icc_lock_application_2019 OK
card_second.tb_icc_lock_application_2020 OK
card_second.tb_icc_lock_application_2021 OK
card_second.tb_icc_lock_application_2022 OK
card_second.tb_icc_lock_application_2023 OK
card_second.tb_icc_lock_application_2024 OK
card_second.tb_icc_lock_application_2025 OK
card_second.tb_icc_lock_application_count OK
card_second.tb_icc_lock_card_2019 OK
card_second.tb_icc_lock_card_2020 OK
card_second.tb_icc_lock_card_2021 OK
card_second.tb_icc_lock_card_2022 OK
card_second.tb_icc_lock_card_2023 OK
card_second.tb_icc_lock_card_2024 OK
card_second.tb_icc_lock_card_2025 OK
card_second.tb_icc_lock_card_count OK
card_second.tb_icc_modify_plate_2019 OK
card_second.tb_icc_modify_plate_2020 OK
card_second.tb_icc_modify_plate_2021 OK
card_second.tb_icc_modify_plate_2022 OK
card_second.tb_icc_modify_plate_2023 OK
card_second.tb_icc_modify_plate_2024 OK
card_second.tb_icc_modify_plate_2025 OK
card_second.tb_icc_modify_plate_count OK
card_second.tb_icc_modify_valid_date_2019 OK
card_second.tb_icc_modify_valid_date_2020 OK
card_second.tb_icc_modify_valid_date_2021 OK
card_second.tb_icc_modify_valid_date_2022 OK
card_second.tb_icc_modify_valid_date_2023 OK
card_second.tb_icc_modify_valid_date_2024 OK
card_second.tb_icc_modify_valid_date_2025 OK
card_second.tb_icc_modify_valid_date_count OK
card_second.tb_icc_statistics OK
card_second.tb_icc_un_lock_application_2019 OK
card_second.tb_icc_un_lock_application_2020 OK
card_second.tb_icc_un_lock_application_2021 OK
card_second.tb_icc_un_lock_application_2022 OK
card_second.tb_icc_un_lock_application_2023 OK
card_second.tb_icc_un_lock_application_2024 OK
card_second.tb_icc_un_lock_application_2025 OK
card_second.tb_icc_un_lock_application_count OK
card_second.tb_icc_unlock_pin_2019 OK
card_second.tb_icc_unlock_pin_2020 OK
card_second.tb_icc_unlock_pin_2021 OK
card_second.tb_icc_unlock_pin_2022 OK
card_second.tb_icc_unlock_pin_2023 OK
card_second.tb_icc_unlock_pin_2024 OK
card_second.tb_icc_unlock_pin_2025 OK
card_second.tb_icc_unlock_pin_count OK
cpc_first.tb_cpc_first_detail_2020 OK
cpc_first.tb_cpc_first_detail_2021 OK
cpc_first.tb_cpc_first_detail_2022 OK
cpc_first.tb_cpc_first_detail_2023 OK
cpc_first.tb_cpc_first_detail_2024 OK
cpc_first.tb_cpc_first_detail_2025 OK
cpc_first.tb_cpc_first_re_detail OK
cpc_first.tb_cpc_first_re_record OK
cpc_first.tb_cpc_first_record_2019 OK
cpc_first.tb_cpc_first_record_2020 OK
cpc_first.tb_cpc_first_record_2021 OK
cpc_first.tb_cpc_first_record_2022 OK
cpc_first.tb_cpc_first_record_2023 OK
cpc_first.tb_cpc_first_record_2024 OK
cpc_first.tb_cpc_first_record_2025 OK
key_manage_platform.tb_key_apply_abolish_detail OK
key_manage_platform.tb_key_apply_abolish_info OK
key_manage_platform.tb_key_apply_detail OK
key_manage_platform.tb_key_apply_info OK
key_manage_platform.tb_key_info OK
key_manage_platform.tb_key_params OK
key_manage_platform.tb_key_purpose OK
key_manage_platform.tb_key_type OK
key_manage_platform.tb_number_rule OK
obu_first.tb_batch_issue_apply OK
obu_first.tb_number_rule OK
obu_first.tb_obu_first_detail_2019 OK
obu_first.tb_obu_first_detail_2020 OK
obu_first.tb_obu_first_detail_2021 OK
obu_first.tb_obu_first_detail_2022 OK
obu_first.tb_obu_first_detail_2023 OK
obu_first.tb_obu_first_detail_2024 OK
obu_first.tb_obu_first_detail_2025 OK
obu_first.tb_obu_first_record_2019 OK
obu_first.tb_obu_first_record_2020 OK
obu_first.tb_obu_first_record_2021 OK
obu_first.tb_obu_first_record_2022 OK
obu_first.tb_obu_first_record_2023 OK
obu_first.tb_obu_first_record_2024 OK
obu_first.tb_obu_first_record_2025 OK
obu_second.tb_obu_activate_2019 OK
obu_second.tb_obu_activate_2020 OK
obu_second.tb_obu_activate_2021 OK
obu_second.tb_obu_activate_2022 OK
obu_second.tb_obu_activate_2023 OK
obu_second.tb_obu_activate_2024 OK
obu_second.tb_obu_activate_2025 OK
obu_second.tb_obu_modify_plate_2019 OK
obu_second.tb_obu_modify_plate_2020 OK
obu_second.tb_obu_modify_plate_2021 OK
obu_second.tb_obu_modify_plate_2022 OK
obu_second.tb_obu_modify_plate_2023 OK
obu_second.tb_obu_modify_plate_2024 OK
obu_second.tb_obu_modify_plate_2025 OK
obu_second.tb_obu_modify_valid_date_2019 OK
obu_second.tb_obu_modify_valid_date_2020 OK
obu_second.tb_obu_modify_valid_date_2021 OK
obu_second.tb_obu_modify_valid_date_2022 OK
obu_second.tb_obu_modify_valid_date_2023 OK
obu_second.tb_obu_modify_valid_date_2024 OK
obu_second.tb_obu_modify_valid_date_2025 OK
obu_second.tb_obu_second_detail_2019 OK
obu_second.tb_obu_second_detail_2020 OK
obu_second.tb_obu_second_detail_2021 OK
obu_second.tb_obu_second_detail_2022 OK
obu_second.tb_obu_second_detail_2023 OK
obu_second.tb_obu_second_detail_2024 OK
obu_second.tb_obu_second_detail_2025 OK
obu_second.tb_obu_second_quality OK
obu_second.tb_obu_second_record_2019 OK
obu_second.tb_obu_second_record_2020 OK
obu_second.tb_obu_second_record_2021 OK
obu_second.tb_obu_second_record_2022 OK
obu_second.tb_obu_second_record_2023 OK
obu_second.tb_obu_second_record_2024 OK
obu_second.tb_obu_second_record_2025 OK
obu_second.tb_params OK
sys.sys_config OK
Upgrade process completed successfully.
Checking if update is needed.
Subject
Written By
Posted
Re: databases are lost
March 17, 2021 07:17AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.