Hello Steve
I have for test purposes used a bpstart_notify with mysqlhotcopy which as I
understand it makes a copy of the MySQL database another place in
filesystem. The downside is that it requires more disk but restore is as
fast as you can copy in the filesystem.
If you use the shutdown/startup approach, make sure in fail situations that
the bpstart_notify dosn't rerun before the bpend_notify is finished, I
usally have used .lock-files for this
Regards
Michael
On Fri, 29 Apr 2005 16:37:27 +0100, Steven Jenner wrote
> Hi, I have been asked by a customer to provide a solution to backing up a
MySQL DB on a system running Fedora Core 3. As I have little knowledge of
MySQL I was wondering if anyone out there had any suggestions on best
practises to perform this function and also best way to then restore the DB.
> The customer does not want to dump the data to a flat file format as they
believe this would take a long time to restore, therefore they have
suggested shutting the DB down and then backing it up whilst it is in a
closed state; is this the best way forward?
> If it is does anyone have any suggestions as to whether the Veritas agent
can set off a script shutting down the DB when the backup starts and then
starting it once it is complete.
> Thanks in advance,
> Steve.
--
Cybercity Webhosting (http://www.cybercity.dk)
|