Re: MySQL Backup

I use this for some very large data sets as well.  The trouble is that=20
to do it right you have to lock the tables while it's running, so I=20
actually run it off replication slaves instead.  One of the nice things=20
of doing things this way is that you can use perl or your other favorite=20
text processing tool to parse out individual databases, tables, views,=20
etc.  That's important in a hosting environment and usually more=20
difficult/costly with raw file backups.

Brian

Tanner Danzey <[email protected]> 2012-04-15 13:10:
>   I usr MySQL's "mysqldump" and a daily cron task that zips it up and sen=
ds
>   it to my NFS backup drive in dated folders. It works just fine for my
>   minute data set.
>
>   On Apr 15, 2012 1:04 PM, "Gerry Smith" <[1][email protected]> wrote:
>
>     What's recommended for MySQL backups these days ?
>     I've been using zmanda, which I found very easy to install and use,
>     but it doesn't seem to be in portage anymore ?
>
>     Thanks,
>
>     Gerry Smith
>
> References
>
>   Visible links
>   1. mailto:[email protected]