… deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to…) engine=innodb; Query OK, 0 rows affected (0.06 sec) mysql> Aborted [root@test3 test]# cp /tmp/test_innodb.frm . cp: overwrite `./test_innodb.frm…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
… needs to have some tables in fresh status. – resharding databases, moving some shards from one server to another. So long story… you just copy table.frm, table.MYD, table.MYI files, but so nice here – just can copy InnoDB tables in fully non… in error.log like: InnoDB: import: extended import of test/img_out59 InnoDB: import: 3 indexes are detected. InnoDB: Progress in %: 1 2…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
… out of MySQL database directory, checks them with MyISAMchk and moves them back to running server. This looks scary but it… created in Innodb dictionary but .frm not created or not completely written. Partially written .frm files or .frm being unsync with internal Innodb dictionary may cause MySQL to fail with wierd error messages. In MySQL 4.1 sync_frm option…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… Assuming I don’t see anything noteworthy here, I’ll move on to the MySQL server. I mean, let’s just… indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might not be.) Or maybe the…. You might find that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (The INFORMATION_SCHEMA…
