List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:November 1 2012 11:47am
Subject:Re: Mysql backup for large databases
View as plain text  

Am 01.11.2012 11:28, schrieb Machiel Richards - Gmail:
> Using mysqldump and restores on an 80-100GB database seems a bit unpractical 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



Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
Mysql backup for large databasesMachiel Richards - Gmail1 Nov
  • Re: Mysql backup for large databasesDimitre Radoulov1 Nov
  • Re: Mysql backup for large databasesReindl Harald1 Nov
    • RE: Mysql backup for large databasesRick James1 Nov
      • Re: Mysql backup for large databasesSinger Wang1 Nov
        • Re: Mysql backup for large databasesReindl Harald1 Nov
          • Re: Mysql backup for large databasesSinger Wang1 Nov
            • Re: Mysql backup for large databasesReindl Harald1 Nov
              • Re: Mysql backup for large databasesmachiel.richards1 Nov
  • Re: Mysql backup for large databasesKaren Abgarian1 Nov
    • Re: Mysql backup for large databasesManuel Arostegui2 Nov
  • Re: Mysql backup for large databasesKaren Abgarian2 Nov
Re: Mysql backup for large databasesReindl Harald1 Nov
RE: Mysql backup for large databasesRick James1 Nov