set global alter_algorithm=INPLACE; RENAME TABLE mysql.time_zone TO mysql.time_zone_BACKUP; RENAME TABLE mysql.time_zone_name TO mysql.time_zone_name_BACKUP; RENAME TABLE mysql.time_zone_transition TO mysql.time_zone_transition_BACKUP; RENAME TABLE mysql.time_zone_transition_type TO mysql.time_zone_transition_type_BACKUP; CREATE TABLE mysql.time_zone LIKE mysql.time_zone_BACKUP; CREATE TABLE mysql.time_zone_name LIKE mysql.time_zone_name_BACKUP; CREATE TABLE mysql.time_zone_transition LIKE mysql.time_zone_transition_BACKUP; CREATE TABLE mysql.time_zone_transition_type LIKE mysql.time_zone_transition_type_BACKUP; DROP TABLE mysql.time_zone; DROP TABLE mysql.time_zone_name; DROP TABLE mysql.time_zone_transition; DROP TABLE mysql.time_zone_transition_type; RENAME TABLE mysql.time_zone_BACKUP TO mysql.time_zone; RENAME TABLE mysql.time_zone_name_BACKUP TO mysql.time_zone_name; RENAME TABLE mysql.time_zone_transition_BACKUP TO mysql.time_zone_transition; RENAME TABLE mysql.time_zone_transition_type_BACKUP TO mysql.time_zone_transition_type; set global alter_algorithm=DEFAULT;