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 yo
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 an