With a slow shutdown, InnoDB performs a full purge and change buffer merge before shutting down, which ensures that data files are fully prepared in case of file format differences between releases.
1 2 3 4
mysql -u root -p --execute="SET GLOBAL innodb_fast_shutdown=0"
[root@server01 soft]# mysql -uroot -p -S /tmp/mysql_3306.sock -e 'set global innodb_fast_shutdown=0' Enter password:
六、关闭数据库
1
shutdown
七、冷备份
1 2
[root@server01 ~]# cd /data [root@server01 data]# cp database database.20240118.bak
[root@server01 mysql]# mysql_upgrade -uroot -p -S /tmp/mysql_3306.sock 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 The sys schema is already up to date (version 1.5.2). Checking databases. stamp.archive_file_record OK stamp.b_analysis_sql OK stamp.b_apply_seal_out OK stamp.b_bill_rule OK stamp.b_bill_rule_setting OK stamp.b_device_corner OK stamp.b_emergency_image OK stamp.b_emergency_used_seal OK stamp.b_execute_user OK stamp.b_face_validate_info OK stamp.b_key_word OK stamp.b_print_info OK stamp.b_remote_authorization OK stamp.b_seal_label OK stamp.b_seal_lowfrequency OK stamp.b_seal_master_warning OK stamp.b_seal_out_info OK stamp.b_seal_out_seal_admin OK stamp.b_seal_statement OK stamp.b_seal_temp_video OK stamp.b_seal_transfer_info OK stamp.b_seal_video OK stamp.b_seal_warning OK stamp.b_seal_warning_image OK stamp.b_seal_warning_longpress OK stamp.b_use_seal_waiting OK stamp.b_used_seal_exception OK stamp.b_used_seal_info OK stamp.b_used_seal_info_relation OK stamp.b_used_seal_report OK stamp.b_used_seal_status OK stamp.b_used_seal_status_relation OK stamp.b_used_seal_times OK stamp.b_used_seal_validate OK stamp.b_warn_seal_admin OK stamp.c_field_mapping OK stamp.c_field_validate OK stamp.c_parameter OK stamp.c_parameter_start OK stamp.c_parameter_sync OK stamp.c_parameter_type OK stamp.c_parameter_type_copy1 OK stamp.c_synchronization_history OK stamp.c_synchronization_strategy OK stamp.cfg_field_mapping OK stamp.cfg_parameter OK stamp.d_dictionary_type OK stamp.d_dictionary_value OK stamp.device_policy_merge OK stamp.emergency_password_log OK stamp.external_setting OK stamp.f_s_disk_file OK stamp.f_s_file OK stamp.f_s_file_cut OK stamp.f_s_file_pretreatment_task OK stamp.f_s_image OK stamp.f_s_img_ocr OK stamp.file_credentials_detail OK stamp.file_credentials_log OK stamp.file_credentials_status OK stamp.l_device_log OK stamp.l_event_log OK stamp.l_exception_log OK stamp.l_login_log OK stamp.l_seal_log OK stamp.l_visit_log OK stamp.log_event_type OK stamp.lowfrequency_warning_setting OK stamp.ocr_check_image OK stamp.ocr_file_page OK stamp.ocr_retry_task OK stamp.ocr_task OK stamp.ocr_task_file OK stamp.ocr_task_report OK stamp.ocr_warning_info OK stamp.password_record OK stamp.r_ocr_similar_word OK stamp.r_risk_image_audit OK stamp.r_risk_level_setting OK stamp.r_risk_type_label OK stamp.r_risk_type_workflow OK stamp.r_risk_workflow_audit OK stamp.rest_role OK stamp.rest_user OK stamp.rest_user_company OK stamp.rest_user_role OK stamp.s_auto_machine OK stamp.s_auto_machine_admin OK stamp.s_device OK stamp.s_device_detail OK stamp.s_device_policy OK stamp.s_device_type OK stamp.s_equipment_package OK stamp.s_module_storage OK stamp.s_seal_access_record OK stamp.s_seal_box_ext OK stamp.s_seal_cabinet OK stamp.s_seal_cabinet_control OK stamp.s_seal_cabinet_log_snapshot OK stamp.s_seal_cabinet_setting OK stamp.s_seal_console OK stamp.s_seal_console_admin OK stamp.s_seal_console_detail OK stamp.s_seal_console_policy OK stamp.s_seal_console_setting OK stamp.s_seal_container OK stamp.s_seal_module OK stamp.s_seal_storage OK stamp.s_storage_box OK stamp.s_storage_goods OK stamp.sc_fdfs OK stamp.seal_admin OK stamp.seal_area OK stamp.seal_auth OK stamp.seal_base OK stamp.seal_base_model_file OK stamp.seal_current_address OK stamp.seal_engrave OK stamp.seal_label OK stamp.seal_location OK stamp.seal_receive OK stamp.seal_statistics OK stamp.seal_used_statistics OK stamp.seal_users OK stamp.sys_aoth OK stamp.sys_archive_template_setting OK stamp.sys_company OK stamp.sys_company_license OK stamp.sys_department OK stamp.sys_expired_policy OK stamp.sys_file_server OK stamp.sys_log OK stamp.sys_menu OK stamp.sys_menu_permission OK stamp.sys_message OK stamp.sys_message_content_key OK stamp.sys_message_error_retry OK stamp.sys_message_receive_user OK stamp.sys_message_template OK stamp.sys_message_template_property OK stamp.sys_message_type OK stamp.sys_plaintext_watermark_setting OK stamp.sys_plaintext_watermark_workflow OK stamp.sys_role OK stamp.sys_role_menu OK stamp.sys_scanner_auth_info OK stamp.sys_seal_expired_policy OK stamp.sys_secret_key OK stamp.sys_security_code OK stamp.sys_setting OK stamp.sys_setting_backup OK stamp.sys_setting_banner OK stamp.sys_similar_word OK stamp.sys_trace_log OK stamp.sys_user OK stamp.sys_user_app OK stamp.sys_user_auth OK stamp.sys_user_department OK stamp.sys_user_external OK stamp.sys_user_feature OK stamp.sys_user_role OK stamp.sys_version OK stamp.sys_water_mark OK stamp.sys_workflow_column OK stamp.t_temp_file OK stamp.theme_setting OK stamp.transfer_used_seal_setting OK stamp.w_form_base OK stamp.w_workflow_apply OK stamp.w_workflow_apply_matrix_form OK stamp.w_workflow_base OK stamp.w_workflow_base_matrix OK stamp.w_workflow_base_relation OK stamp.w_workflow_column OK stamp.w_workflow_countersign OK stamp.w_workflow_line OK stamp.w_workflow_line_relation OK stamp.w_workflow_matrix_base OK stamp.w_workflow_matrix_detail OK stamp.w_workflow_model OK stamp.w_workflow_model_relation OK stamp.w_workflow_node OK stamp.w_workflow_node_relation OK stamp.w_workflow_opinion OK stamp.w_workflow_seal_log OK stamp.w_workflow_seal_log_operator OK stamp.w_workflow_setting OK stamp.w_workflow_step OK stamp.w_workflow_step_data OK stamp.w_workflow_step_relation OK stamp.w_workflow_step_user OK stamp.w_workflow_user OK stamp.websocket_message_log OK stamp.wf_change_seal OK stamp.wf_change_seal_status OK stamp.wf_create_seal OK stamp.wf_transfer_seal OK stamp.wf_used_seal OK stamp.wf_used_seal_relation OK stamp.xxl_job_group OK stamp.xxl_job_info OK stamp.xxl_job_lock OK stamp.xxl_job_log OK stamp.xxl_job_log_report OK stamp.xxl_job_logglue OK stamp.xxl_job_registry OK stamp.xxl_job_user OK sys.sys_config OK Upgrade process completed successfully. Checking if update is needed.
十一、加载新的帮助表
1 2
[root@server01 mysql]# mysql -uroot -p mysql -S /tmp/mysql_3306.sock < /usr/local/mysql/share/fill_help_tables.sql Enter password:
