From: hais
Date: October 17 2012 8:14pm
Subject: proper backup on windows platform
List-Archive: http://lists.mysql.com/win32/19180
Message-Id: <2868FBA6D887044090AC98D58CDD4495250C001E@GHCMAIL.ghcdom.loc>
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="_000_2868FBA6D887044090AC98D58CDD4495250C001EGHCMAILghcdomlo_"
--_000_2868FBA6D887044090AC98D58CDD4495250C001EGHCMAILghcdomlo_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hello. I am a new user of MySQL and do not know which is the correct group =
to post this to. I hope I did not violate protocol by sending it to two gro=
ups at once. I am running MySQL on a Microsoft server 2008R2. I use powersh=
ell scripts that execute wbadmin.exe and make operating system images. I us=
e this method with Microsoft databases that have a Microsoft VSS writer tha=
t puts the database into what I think is called a "consistent state" for ba=
ckup. I am ok with not splitting out the MySQL database backup as a separat=
e data set and am ok with having it be a part of the image I create of the =
operating system. If I use a Microsoft "net" command in my script to stop t=
he MySQL service and then perform an image backup with wbadmin.exe and then=
start the MySQL service again with a "net" command, is that an acceptable =
backup practice? Is this putting the MySQL database in a consistent state f=
or backup? Thank you for your time and consideration of this matter - dale =
haisman
--_000_2868FBA6D887044090AC98D58CDD4495250C001EGHCMAILghcdomlo_--