mysql dump on a cron job. You write the dump pipe it to gzip and set the name with the date and life is golden. On Wed, May 19, 2010 at 3:50 PM, keith smith wrote: > > Very good points! What is an easy way to automate backing up a dozen or so > tables on a MySql Server? > > ------------------------ > Keith Smith > > --- On *Wed, 5/19/10, Alex Dean * wrote: > > > From: Alex Dean > > Subject: Re: load balanced configuration > To: "Main PLUG discussion list" > Date: Wednesday, May 19, 2010, 3:07 PM > > > > On May 19, 2010, at 4:07 PM, keith smith wrote: > > > > > In a nutshell I am trying to create an automated backup that is a > automated fail over solution. > > Keep in mind that failover/HA is not the same as backup. It makes sense > that both servers can do both jobs (you could keep your backups on both your > production servers), but the failover/replication process should not be > considered a backup process. > > I understand 'high availability' to mean that both servers will have access > to the same (or nearly the same) data, so either one could be primary. In > that case, anything which happens on your primary should automatically be > replicated/synced/whatever to your secondary. If you get hacked and someone > does 'DROP DATABASE yourcart;', it's gone from both servers. > > Making an hourly or daily backup of your data & critical files, and storing > them elsewhere, is crucial. Then... practice the steps needed to actually > use those backups. Discovering that your backups require 18 hours of > restore time before you can get them into production is awful. Doubly awful > if you discover it only when you actually need to use them. Yes, it > happened to me. :) > > alex > --------------------------------------------------- > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > To subscribe, unsubscribe, or to change your mail settings: > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > > > > --------------------------------------------------- > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > To subscribe, unsubscribe, or to change your mail settings: > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss >