Gentoo Archives: gentoo-user

From: Nikos Chantziaras <realnc@×××××.de>
To: gentoo-user@l.g.o
Subject: [gentoo-user] Re: Web server mirror
Date: Wed, 08 Apr 2009 20:32:38
Message-Id: grj1k6$8jq$1@ger.gmane.org
In Reply to: Re: [gentoo-user] Re: Web server mirror by Momesso Andrea
1 Momesso Andrea wrote:
2 > Ok, but what about databases? Joomla has his own and mediawiki too...
3 > Just dump it and copy it? Will it work?
4
5 It will work. The way I do it with AutoMySQLBackup:
6
7 http://members.lycos.co.uk/wipe_out/automysqlbackup
8
9 It's a simple but powerful script that backs up MySQL databases (all of
10 them by specifying "all" or just a select few). It keeps 4 copies per
11 month (one for each week), 7 copies per week (one for each day), one
12 latest copy plus monthly ones. You put it in /etc/cron.daily, edit it
13 and make it executable. It has documentation so you can probably figure
14 it out easily.
15
16 If the main machine goes down, you import all the backed up databases on
17 the other machine.
18
19 Another way to do it is to run MySQL on the same machine that does the
20 NAT, but in this case you can not operate both machines behind it at the
21 same time (that would mean the two Joomlas installed on both would try
22 to access the same database at the same time; that won't work and will
23 probably damage the database.)