InnoDB Hot Backup is non-free and works only with InnoDB. mysqlhotcopy is free and works with MyISAM tables but not InnoDB.
mysqldump is free and works with both. The easiest thing to do is use mysqldump...you'll get text files that contain create and insert statements allowing you to restore you tables in MySQL. It's easy b/c it works with both major table types. The issue is that it's much slower then mysqlhotcopy (and presumably InnoDB Hot Backup). --Ware alx wrote: >Hi all >I'm new to this part of mysql. I've never done somme kind of backup/dump >with mysql >I read that for myIsam I can Just copy the frm, idx form the database >directory > >But >I've to manage hot backup with a database mixed with InnoDB tables and >MyIsam. I searched for a tutorial / a software or any other kinda of >information >But there is something I don't understand: >Mysql HOt Backup is a non-free solution >Does it works onyl with InnoDB or also with MyIsam >Can Someone suggest me some way to follow ? >TIA >Alx >-- >alx <[EMAIL PROTECTED]> > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
