From: Michael Dykman Date: September 14 2009 3:28pm Subject: Re: HOW TO Backup a mysql innodb on windows? List-Archive: http://lists.mysql.com/mysql/218719 Message-Id: <814b9a820909140828i300ac55bkbf41b6c5c50860a5@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable 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. Otherwise, the data will load just fine. - michael dykman On Mon, Sep 14, 2009 at 11:14 AM, Todd Lyons wrote: > On Mon, Sep 14, 2009 at 7:44 AM, N=E9stor wrote: >> Maybe one of you experts know the answer. >> >> I have a Innodb database that I want to back up. =A0 Is there a free too= l to >> do this? >> mysqlhotbackup is a paid tool, is that the only one available? > > You can also use the free tool from Percona which can backup innodb > tables without having to shutdown or read lock the database (but it > does read lock the database while copying *.frm files for Innodb > tables and any MyISAM tables). > > http://www.percona.com/docs/wiki/percona-xtrabackup:start > >> If I do a mysqldump of the innodb databse, will I be avail to uploaded i= nto >> a myisam >> database and will it work? > > Depends. =A0If you use foreign keys in innodb, then you cannot import > that into myisam because myisam does not support foreign keys. =A0If you > do not use foreign keys, it should work. > -- > Regards... =A0 =A0 =A0Todd > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail= .com > > --=20 - michael dykman - mdykman@stripped Don=92t worry about people stealing your ideas. If they=92re any good, you=92ll have to ram them down their throats! Howard Aiken