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 the

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 to

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

[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

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 momesso.and...@gmail.comwrote: I run on an old laptop a website (Joomla + MediaWiki + Moodle + a couple of other things). The site now is offline and

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.pgp

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

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. mysqlbackup

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.