On Mon, Sep 14, 2009 at 7:44 AM, Néstor <rot...@gmail.com> wrote: > Maybe one of you experts know the answer. > > I have a Innodb database that I want to back up. Is there a free tool 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 into > a myisam > database and will it work? Depends. If you use foreign keys in innodb, then you cannot import that into myisam because myisam does not support foreign keys. If you do not use foreign keys, it should work. -- Regards... Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
