linuxaudio.org

--nextPart1487048.YsVN4sEH5S

Content-Type: Text/Plain;

  charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable
Hi,
On Monday 13 September 2010 16:55:29 Ivan Tarozzi wrote:

quoted text
> Il giorno lun, 13/09/2010 alle 07.43 -0700, Mark Knecht ha scritto:

> > If you run mysql then back up databases as Arnold suggests.

>=20

> This is true, but may be you need to pay attention about online backup

> of mysql files.

> I'm not sure, but if you backup files of a running mysql database, the

> restore of these backups may fails.

My mysql is only used privately, basically no usage during the cron-backup-

run. And I can say from experience that this works. The backup can be broug=

ht=20

up again without problems. It might be a problem when mysql changes these f=

iles=20

during the buckup-run. But thats what the snapshot function of lvm is for...
> I read about mysql backup tecniques using cron to create a mysql backup

quoted text
> (using mysql internal commands:mysqldump and mysqlhotcopy) and then

> backup the resulting offline files.

That is possible too. With the lvm-snapshot you get backups from a certain=

=20

point in time. The techniques from mysql itself are afaik more targeted at=

=20

continuous live-backup preferable to a hot-standby machine. But I don't rea=

lly=20

know the details here...
Have fun,
Arnold
--nextPart1487048.YsVN4sEH5S

Content-Type: application/pgp-signature; name=signature.asc

Content-Description: This is a digitally signed message part.
-----BEGIN PGP SIGNATURE-----

Version: GnuPG v1.4.10 (GNU/Linux)
iEYEABECAAYFAkyOPtYACgkQuYLL1cDjHx3/OACfQ/55QElYOfpW9mtIFyXaIlyN

JrMAnRGshKRf7JD/v6IZkvNmtmMt2STn

=qfSM

-----END PGP SIGNATURE-----
--nextPart1487048.YsVN4sEH5S--