Re: [BackupPC-users] mysql addon or plugin?

2011-03-25 Thread hansbkk
MySQLdump is a good tool, there are others, but usually the whole process is scripted to fit the local environment. Just like many mail servers, databases should be quiescent (the server stopped) while the dump takes place to ensure consistency. If you want to really minimize the downtime, then us

[BackupPC-users] mysql addon or plugin?

2011-03-25 Thread Lord Sporkton
I have seen some examples of using a local backup script to dumpmysql to a local dir, then backup that local dir via BPC, but i was hoping for something a little more robust. I was looking into replacing the tar commands that pipe back to ssh with a mysqldump command so it pipes one big sqldump fil

Re: [BackupPC-users] backend to nfs nas share

2011-03-25 Thread Lord Sporkton
I was planning to make my backend storage box with zfs which as i understand it support easy expansion to multiple new disks. Then run either iSCSI or NFS between the backend storage box and the front end BPC box On 23 March 2011 21:34, wrote: > Best to use LVM (over RAID if you like) for future

Re: [BackupPC-users] Keeping 1 "golden" backup for a year

2011-03-25 Thread Matthias Meyer
Brad Alexander wrote: > Okay, this kind of confuses me. I would like to have the following backup > strategy: > > 6 incrementals (*2) > 1 weekly (*2) > 1 yearly (*1) > > Currently, > > $Conf{FullKeepCnt} = [ 1, 0, 1, 0, 0, 1 ]; > > I know this isn't right, but it's not what I would anticipate

Re: [BackupPC-users] Keeping 1 "golden" backup for a year

2011-03-25 Thread Les Mikesell
On 3/25/2011 10:36 AM, Brad Alexander wrote: > Okay, this kind of confuses me. I would like to have the following > backup strategy: > > 6 incrementals (*2) > 1 weekly (*2) > 1 yearly (*1) > > Currently, > > $Conf{FullKeepCnt} = [ 1, 0, 1, 0, 0, 1 ]; > > So how should I set up my FullKeepCnt to ke

[BackupPC-users] Keeping 1 "golden" backup for a year

2011-03-25 Thread Brad Alexander
Okay, this kind of confuses me. I would like to have the following backup strategy: 6 incrementals (*2) 1 weekly (*2) 1 yearly (*1) Currently, $Conf{FullKeepCnt} = [ 1, 0, 1, 0, 0, 1 ]; I know this isn't right, but it's not what I would anticipate seeing. For instance, one of my backup targets