[gentoo-server] MySQL Backup

[gentoo-server] MySQL Backup

[Gerry Smith]

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

Re: [gentoo-server] MySQL Backup

[kojiro]

[-- Attachment #1: Type: text/plain, Size: 253 bytes --]

Tar+ssh

Gerry Smith <smith.gerry@gmail.com> 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


[-- Attachment #2: Type: text/html, Size: 593 bytes --]

Re: [gentoo-server] MySQL Backup

[Tanner Danzey]

[-- Attachment #1: Type: text/plain, Size: 435 bytes --]

I usr MySQL's "mysqldump" and a daily cron task that zips it up and sends
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" <smith.gerry@gmail.com> 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
>
>

[-- Attachment #2: Type: text/html, Size: 724 bytes --]

RE: [gentoo-server] MySQL Backup

[Jesse Pasichnyk]

[-- Attachment #1: Type: text/plain, Size: 58 bytes --]

I run backuppc, calling MySQL dump as a pre-backup task...

[-- Attachment #2: Type: text/html, Size: 1792 bytes --]

Re: [gentoo-server] MySQL Backup

[Robert Bridge]

We use xtrabackup from percona, with tar to generate backup of the
running mysql servers in a fraction of the time it would take to use
mysqldump. Restoration is than just a case of copy the uncompressed
tarball into place and starting mysql.

It's a pain when it comes to restoring individual tables, but for a
full system backup it's fast and easy.

RobbieAB.

On 15 April 2012 20:40, Jesse Pasichnyk <jesse@pasichnyk.net> wrote:
> I run backuppc, calling MySQL dump as a pre-backup task...
> ________________________________
> From: Tanner Danzey
> Sent: 4/15/2012 10:56 AM
> To: gentoo-server@lists.gentoo.org
> Subject: Re: [gentoo-server] MySQL Backup
>
>
> I usr MySQL's "mysqldump" and a daily cron task that zips it up and sends 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" <smith.gerry@gmail.com> 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
>>
>

Re: [gentoo-server] MySQL Backup

[Brian Kroth]

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

Brian

Tanner Danzey <arkaniad@gmail.com> 2012-04-15 13:10:
>   I usr MySQL's "mysqldump" and a daily cron task that zips it up and sends
>   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]smith.gerry@gmail.com> 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:smith.gerry@gmail.com