I am trying to find the best way to backup my 4.7GB database and have unfortunately found out the hard way that mysqldump is grossly inefficient. Since 4 web sites rely on the data, shutting it down to copy it is not a good option either. Has anyone used mysqlhotcopy? The perl doc says it is still in beta, which makes me a little nervous.

Thanks in advance!