MySQL Forums
Forum List  »  General

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.

Options: ReplyQuote


Subject
Written By
Posted
March 02, 2021 03:33AM
March 02, 2021 11:25AM
March 09, 2021 08:31PM
March 09, 2021 09:17PM
March 09, 2021 09:25PM
March 10, 2021 10:08AM
March 10, 2021 07:53PM
March 10, 2021 09:23PM
March 11, 2021 12:11AM
March 11, 2021 05:36AM
March 11, 2021 06:39AM
March 11, 2021 09:37AM
March 11, 2021 08:04PM
March 12, 2021 09:11AM
March 12, 2021 07:36PM
March 12, 2021 08:17PM
March 12, 2021 08:41PM
March 13, 2021 09:41AM
March 15, 2021 10:03AM
March 15, 2021 11:34AM
March 15, 2021 08:45PM
March 15, 2021 09:10PM
March 15, 2021 09:26PM
March 15, 2021 09:38PM
March 15, 2021 09:47PM
March 15, 2021 10:30PM
March 16, 2021 09:24PM
March 16, 2021 10:31PM
March 16, 2021 11:09PM
March 17, 2021 07:08AM
Re: databases are lost
March 17, 2021 07:17AM
March 15, 2021 09:56PM
March 17, 2021 11:16AM
March 19, 2021 12:02AM


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.