This is a multi-part message in MIME format.
------_=_NextPart_001_01C54CD4.A94335C6
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
While I don't think it's the best way, we back up some database servers
like this.
=20
Put a bpstart_notify script on the server that runs the DB shutdown
command, and a bpend_notify script that restarts it.
=20
Pretty simple.
=20
Paul
-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] On Behalf Of Steven
Jenner
Sent: April 29, 2005 11:37 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] MySQL backups using Veritas Netbackup
Importance: High
=09
=09
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,=20
Steve.=20
------_=_NextPart_001_01C54CD4.A94335C6
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial color=3D#800000 size=3D2><SPAN =
class=3D672555815-29042005>While=20
I don't think it's the best way, we back up some database =
servers like=20
this.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2><SPAN=20
class=3D672555815-29042005></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2><SPAN =
class=3D672555815-29042005>Put a=20
bpstart_notify script on the server that runs the DB shutdown command, =
and a=20
bpend_notify script that restarts it.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2><SPAN=20
class=3D672555815-29042005></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2><SPAN =
class=3D672555815-29042005>Pretty=20
simple.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2><SPAN=20
class=3D672555815-29042005></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2><SPAN=20
class=3D672555815-29042005>Paul</SPAN></FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #800000 2px =
solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr =
align=3Dleft><FONT=20
face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B>=20
veritas-bu-admin AT mailman.eng.auburn DOT edu=20
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] <B>On Behalf Of =
</B>Steven=20
Jenner<BR><B>Sent:</B> April 29, 2005 11:37 AM<BR><B>To:</B>=20
veritas-bu AT mailman.eng.auburn DOT edu<BR><B>Subject:</B> [Veritas-bu] =
MySQL=20
backups using Veritas Netbackup<BR><B>Importance:</B>=20
High<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face=3DArial size=3D2>Hi, I have been asked by a customer to =
provide a=20
solution to backing up a MySQL DB on a system running Fedora Core 3. =
As I have=20
little knowledge of MySQL I was wondering if anyone out there had any=20
suggestions on best practises to perform this function and also best =
way to=20
then restore the DB.</FONT></P>
<P><FONT face=3DArial size=3D2>The customer does not want to dump the =
data to a=20
flat file format as they believe this would take a long time to =
restore,=20
therefore they have suggested shutting the DB down and then backing it =
up=20
whilst it is in a closed state; is this the best way =
forward?</FONT></P>
<P><FONT face=3DArial size=3D2>If it is does anyone have any =
suggestions as to=20
whether the Veritas agent can set off a script shutting down the DB =
when the=20
backup starts and then starting it once it is complete.</FONT></P>
<P><FONT face=3DArial size=3D2>Thanks in advance,</FONT> </P>
<P><FONT face=3DArial size=3D2>Steve.</FONT> =
</P></BLOCKQUOTE></BODY></HTML>
=00
------_=_NextPart_001_01C54CD4.A94335C6--
|
