On Tuesday 23 November 2004 02:12 pm, Titus wrote: > I have converted some tables from MyISAM to INNO > using an ALTER TABLE statement. It seems to work > fine. However, when I copy that database to another > directory for purposes of backup, a subsequent 'use' > statement on the backup directory (db) reports that > > Didn't find any fields in table 'tblAssays' > > After exploring I get a report that > > Can't open file: 'tblAssays.InnoDB' (errno: 1) > > Can anyone shed any light on this problem? Many > thanks.
Only two ways to make copies of innodb.. mysqlhotcopy (its not free) and mysqldump.. This is assuming your not coping the entire db directory tree.. Maybe someone else knows of another. Jeff
pgp9Z7ari8lOX.pgp
Description: PGP signature
