Hi Folks
I'm looking for some advice or best practices... there are several ways =
to create a backup of a MySQL database, and there are some constraints =
depending on the type of tables used (InnoDB vs MyISAM). It seems to me =
that the important criteria would be:
1) reliability=20
2) total time that the site can serve pages at a decent speed
2a) total time to create the backup=20
2b) total time with locks in place (or total time slash can't do =
updates)
3) flexibility
What do you do? hotcopy? mysqldump? Something else?
Thanks
Mark