From: Todd Lyons Date: September 14 2009 3:34pm Subject: Re: HOW TO Backup a mysql innodb on windows? List-Archive: http://lists.mysql.com/mysql/218720 Message-Id: <48b1344b0909140834r30bfc284ob41ec7a23af282c@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On Mon, Sep 14, 2009 at 8:28 AM, Michael Dykman wrote: > If I may, > > If you have foreign keys on your InnoDB, you can still import your > data to MyISAM but foreign keys will be lost. =A0Otherwise, the data > will load just fine. Very good point. My comment was based on the possibly erroneous assumption that if you were using foreign keys, when you switched to MyISAM you wanted to continue to use foreign keys. Without the op saying one way or the other, Michael's answer is more correct than mine. --=20 Regards... Todd