MySQL data files are binary compatible from one machine to another.
Even InnoDB
data files. As long as you are not trying to "upgrade" from version 3.23 to
version 4.1, you are okay with copying the data files from one machine to
another.
--
Partha Dutta
Sr. Consultant, MySQL Inc.
Quoting Chris
Brian Erickson wrote:
>Greetings all,
>
>We are migrating our web site from one server to another and are
>having some issues with transferring our MySQL database. Here's the
>process we're currently using:
>
>1) run mysqldump for each table in our database (i.e. one file for each table)
>2) compr
Temporary replication comes to mind fs hot copy as well (maybe)
--
Chris.
I love deadlines. I especially love the whooshing sound they make as they
fly by..." - Douglas Adams, 'Hitchhiker's Guide to the Galaxy'
- Original Message -
From: "Brian Erickson" <[EMAIL PROTECTED]>
To: