Re: database backup
2002-11-27 12:13:49
On Wed, Nov 27, 2002 at 07:47:55AM -0800, Jerry wrote:
> I'd like to stop a mysql database for a backup runs,
> and start it back up after the backup.
>
> I was thinking of putting a wrapper around amandad,
> but I am not sure if that would work because amanda
> makes a connection to amanadad then runs
> sendbackup.... so although I could stop the database,
> I would need a way to know when sendbackup is done to
> start the database backup. or am I totally off?
What about a wrapper around the backup program itself,
tar or dump? It could examine the args searching and
determine if the entry being done is the db partition.
If so, stop it before executing the real program with
the same args. When that program exits, restart
the db.
Your wrapper could also examing the "output" arg.
I think during estimates this is /dev/null. It may
not be necessary to stop the db during those runs.
--
Jon H. LaBadie jon AT jgcomp DOT com
JG Computing
4455 Province Line Road (609) 252-0159
Princeton, NJ 08540-4322 (609) 683-7220 (fax)
|
|
|