[mythtv-users] Backing up mysql database.
drayson at net1plus.com
Sun Sep 9 12:08:26 UTC 2007
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Tom Metro
Sent: Sunday, September 09, 2007 1:05 AM
To: Discussion about mythtv
Subject: Re: [mythtv-users] Backing up mysql database.
Michael T. Dean wrote:
> Tom Metro wrote:
>> . /etc/mythtv/mysql.txt
> Just be very careful not to let any stray commands in your
> mysql.txt--especially if running the script as root. :)
Good point, but I ran the script as the mythtv user, which is the same
user that owns /etc/mythtv/mysql.txt.
> Theoretically, I should never need it considering both my frontend and
> backend mirrored OS drives.
Not true. Mirroring saves you from hardware failure in one drive. It
doesn't save you from software or human error. A failed upgrade could
theoretically trash your database. Having historical archives is good
insurance against that.
mythtv-users mailing list
mythtv-users at mythtv.org
That would be true if I didn't do what I do.. I split the mirror before I
upgrade. That way if something does get screwed up during the upgrade I have
the other copy to work from.
See, when I upgrade its not just myth that I upgrade, I upgrade my entire
system as well. Having a complete drive copy to restore is great.
More information about the mythtv-users