From: Johan De Meersman Date: March 22 2011 1:01pm Subject: Re: Question about Backup List-Archive: http://lists.mysql.com/mysql/224696 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit You are assuming that the database is one table of 5.000 gigabyte, and not 5.000 tables of one gigabyte; and that the backup needs to be consistent :-p ----- Original Message ----- > From: "Reindl Harald" > To: mysql@stripped > Sent: Monday, 21 March, 2011 12:44:08 PM > Subject: Re: Question about Backup > > Forget mysqldump because TABLE LOCKS for so hughe databases > I would setup a replication-slave because you can stop > the salave and make a filesystem-backup of the whole db-folder > while the production server is online, we do this with our > dbmail-server since 2009 > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel