On Wed, Nov 28, 2001 at 03:49:16PM -0000, Martyn Drake wrote:

Hi folks,

Does anybody have any hints or tips for dumping or performing live backups of large mySQL databases? I've heard about mysqlhotcopy, but I think that's being a bit too simplistic for my needs..

Any reason not to use mysqldump?

Alternatively, what about using replication? - this seems to be very stable now...