Re: [gentoo-user] Best website backup practice

2008-12-20 Thread Mick
On Friday 19 December 2008, kashani wrote: > Mick wrote: > > Aha! Never done this. How would you go about it? > > To be honest I've never attempted it. Most of my recent installations > have been large enough where having an actual backup server was a > requirement. However Gentoo does include th

Re: [gentoo-user] Best website backup practice

2008-12-19 Thread kashani
Mick wrote: On Wednesday 17 December 2008, kashani wrote: Momesso Andrea wrote: So there is no way if I want to keep the databases runnung? If your database isn't terribly busy I'd setup a second Mysql instance on the same machines and make it a slave of your primary. Then when it's

Re: [gentoo-user] Best website backup practice

2008-12-19 Thread Mick
On Wednesday 17 December 2008, kashani wrote: > Momesso Andrea wrote: > > So there is no way if I want to keep the databases runnung? > > If your database isn't terribly busy I'd setup a second Mysql instance > on the same machines and make it a slave of your primary. Then when it's > time t

Re: [gentoo-user] Best website backup practice

2008-12-17 Thread kashani
Momesso Andrea wrote: On Wed, Dec 17, 2008 at 01:03:46PM -0800, kashani wrote: I like LVM snapshotting for databases, but that takes some planning and you have to stop the database. However your mysqlbackup are actually very unsafe because I know for certain that Mediawiki uses Innodb tables.

Re: [gentoo-user] Best website backup practice

2008-12-17 Thread Momesso Andrea
On Wed, Dec 17, 2008 at 01:03:46PM -0800, kashani wrote: > I like LVM snapshotting for databases, but that takes some planning and > you have to stop the database. However your mysqlbackup are actually very > unsafe because I know for certain that Mediawiki uses Innodb tables. > mysqlbacku

Re: [gentoo-user] Best website backup practice

2008-12-17 Thread kashani
Momesso Andrea wrote: On Wed, Dec 17, 2008 at 10:55:36AM -0800, Kyle Bader wrote: This is a great method that I utilize: http://www.mikerubel.org/computers/rsync_snapshots/ And what about the database? I like LVM snapshotting for databases, but that takes some planning and you have

Re: [gentoo-user] Best website backup practice

2008-12-17 Thread Momesso Andrea
On Wed, Dec 17, 2008 at 10:55:36AM -0800, Kyle Bader wrote: >This is a great method that I utilize: > >http://www.mikerubel.org/computers/rsync_snapshots/ > And what about the database? === http://topperh.blogspot.com === pgpP5H7h5icch.p

Re: [gentoo-user] Best website backup practice

2008-12-17 Thread Kyle Bader
This is a great method that I utilize: http://www.mikerubel.org/computers/rsync_snapshots/ On Wed, Dec 17, 2008 at 9:02 AM, Momesso Andrea wrote: > I run on an old laptop a website (Joomla + MediaWiki + Moodle + a couple > of other things). > > The site now is offline and I'm ok with my automate

[gentoo-user] Best website backup practice

2008-12-17 Thread Momesso Andrea
I run on an old laptop a website (Joomla + MediaWiki + Moodle + a couple of other things). The site now is offline and I'm ok with my automated backups of all the hard drive, but it's going to go online in a few weeks and I'd like to add some more security. What I'd like to have is periodic snap