Portál AbcLinuxu, 11. května 2025 07:21
select file_id, file_name, ENGINE from INFORMATION_SCHEMA.FILES order by file_id; +---------+-----------------------------------------------+--------+ | file_id | file_name | ENGINE | +---------+-----------------------------------------------+--------+ | 0 | ./ibdata1 | InnoDB | | 9 | ./haha/adresy.ibd | InnoDB | | 10 | ./haha/bracket.ibd | InnoDB | | 11 | ./haha/bracket_photo.ibd | InnoDB | | 12 | ./haha/load.ibd | InnoDB | | 13 | ./haha/load_queue.ibd | InnoDB | | 14 | ./haha/office.ibd | InnoDB | | 15 | ./haha/office_fill_group.ibd | InnoDB | | 16 | ./haha/office_fill.ibd | InnoDB | | 17 | ./haha/office_fantom.ibd | InnoDB | | 18 | ./haha/office_product_cat.ibd | InnoDB | | 19 | ./haha/office_product_typ.ibd | InnoDB | | 20 | ./haha/order_groupy.ibd | InnoDB | | 21 | ./haha/partnerx.ibd | InnoDB | | 22 | ./haha/phonebook.ibd | InnoDB | | 23 | ./haha/product_cat.ibd | InnoDB | | 24 | ./haha/product_typ.ibd | InnoDB | | 25 | ./haha/ratio.ibd | InnoDB | | 26 | ./haha/sources.ibd | InnoDB | | 27 | ./haha_web/xp_leading.ibd | InnoDB | ...A takto na nově postaveném slave:
select file_id, file_name, ENGINE from INFORMATION_SCHEMA.FILES order by file_id; +---------+---------------------------------------+--------+ | file_id | file_name | ENGINE | +---------+---------------------------------------+--------+ | 0 | ./ibdata1 | InnoDB | | 2 | ./mysql/plugin.ibd | InnoDB | | 3 | ./mysql/servers.ibd | InnoDB | | 4 | ./mysql/help_topic.ibd | InnoDB | | 5 | ./mysql/help_category.ibd | InnoDB | | 6 | ./mysql/help_relation.ibd | InnoDB | | 7 | ./mysql/help_keyword.ibd | InnoDB | | 8 | ./mysql/time_zone_name.ibd | InnoDB | | 9 | ./mysql/time_zone.ibd | InnoDB | | 10 | ./mysql/time_zone_transition.ibd | InnoDB | | 11 | ./mysql/time_zone_transition_type.ibd | InnoDB | | 12 | ./mysql/time_zone_leap_second.ibd | InnoDB | | 13 | ./mysql/innodb_table_stats.ibd | InnoDB | | 14 | ./mysql/innodb_index_stats.ibd | InnoDB | | 15 | ./mysql/slave_relay_log_info.ibd | InnoDB | | 16 | ./mysql/slave_master_info.ibd | InnoDB | | 17 | ./mysql/slave_worker_info.ibd | InnoDB | | 18 | ./mysql/gtid_executed.ibd | InnoDB | | 19 | ./mysql/server_cost.ibd | InnoDB | | 20 | ./mysql/engine_cost.ibd | InnoDB | | 21 | ./sys/sys_config.ibd | InnoDB | | 24 | ./ibtmp1 | InnoDB | +---------+---------------------------------------+--------+ 22 rows in set (0.00 sec)Nevěděl byste někdo jak to vyřešit a opravit? Protože teď si samosebou databázi mysql ani nemůžu zazálohovat pomocí mysqldump, protože to skončí na chybě. mysqldump: Got error: 1146: Table 'mysql.engine_cost' doesn't exist when using LOCK TABLES
Na otázku zatím nikdo bohužel neodpověděl.
Tiskni
Sdílej:
ISSN 1214-1267, (c) 1999-2007 Stickfish s.r.o.