----- Original Message -----
From: "Paul DuBois" <paul@stripped>
Sent: Wednesday, August 07, 2002 3:59 AM
Subject: Re: Can mysqldump be trusted?
> At 9:55 -0400 8/6/02, Tim Endres wrote:
> >Furthermore, mysqldump output is portable. The data files are not.
> Depends on the table type. ISAM and BDB tables are not portable.
> MyISAM tables are. InnoDB tables are if they don't include floating-point
> columns (although you'd have to copy the entire InnoDB tablespace rather
> than individual files).
Both MyISAM and InnoDB binary data files (ibdata or .MYD, .MYI) can be moved
to any other computer if you do not have floating point columns in your
If you have floats, then both in the case of MyISAM and InnoDB you can move
the files if the floating point formats of the computers are the same. That
means you can always move files between any Intel x86 computers, regardless
of the operating system. I think most other processors also have the Intel
floating point format, but I do not have a list of them.
> >> I would not recommend copying the file structure.
> >> IMHO, mysqldump is a lot safer if you have use the correct parameters
> >> dump command (lock tables, flush, delayed insert, etc.). Study the
> >> options in mysqldump.
> >> When you copy the file structure, there is a risk that a query will be
> >> progress, potentially corrupting tables. If you are going to copy
> >> should at least shut the server down.
> > > Gerald Jensen
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com