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
Am 21.03.2011 12:23, schrieb Pedro Nuñez: > Hi > > I need set up a backup strategy for a mysql database in a ubuntu server, > the database will grow up to a 5TB. > What would be the best option ?? Maybe a script that uses mysqldump?? There > is a better way to do this? > > Thanks in advance to all > Pedro. -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/
signature.asc
Description: OpenPGP digital signature
