From: Reindl Harald
Date: November 1 2012 11:47am
Subject: Re: Mysql backup for large databases
List-Archive: http://lists.mysql.com/mysql/228562
Message-Id: <5092613B.9030403@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigF1EFB085ABA61E8AA279CB5F"

--------------enigF1EFB085ABA61E8AA279CB5F
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 01.11.2012 11:28, schrieb Machiel Richards - Gmail:
> Using mysqldump and restores on an 80-100GB database seems a bit unprac=
tical as the restore times seems to
> get quite long as well as the backup times.

* setup a master/slave configuration
* stop the slave
* rsync the raw datadir to whatever backup-medium/location
* start the salve again



--------------enigF1EFB085ABA61E8AA279CB5F
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://www.enigmail.net/

iEYEARECAAYFAlCSYTsACgkQhmBjz394AnlCuQCeI1d8ujgpOf/b8sdUqY69/WbM
RXoAn2PTj8yCljNtR2F+El9MhQSyKW8S
=KEzJ
-----END PGP SIGNATURE-----

--------------enigF1EFB085ABA61E8AA279CB5F--