… to convert MyISAM tables to InnoDB. …InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (The INFORMATION_SCHEMA query will surely trigger…copy of the table, make the proposed modifications to it, and show the difference afterwards. Or we might have a test server to…
Comment: Connecting orphaned .ibd files
May 13, 2011 By 12 Comments
… Triggering myisam-recover for all MyISAM tables May 16 14:19:30 debian mysqld: 110516 14:19:30 InnoDB:… copied the InnoDB May 16 14:19:30 debian mysqld: InnoDB: tablespace but not the InnoDB log…InnoDB tablespace.” ? Must I import .ibd into an empty database ? In this case ibdconnect does not need to…
Comment: xtrabackup-0.5, bugfixes, incremental backup introduction
April 9, 2009 By 6 Comments
Leon, To restore data you can copy backup to final /data directory directly and run innobackupex –apply-log /data … to start. As for trigger/user it depends what tool you use. xtrabackup binary works only with innodb tables. innobackupex handles all instance including MyISAM…
