> -----Original Message----- > From: Madscientist [mailto:[EMAIL PROTECTED]
> We use this mechanism, but we do our mysqldumps from a slave > so the time doesn't matter. Excellent idea. > Interesting side effect: A GZIP of the data files is _huge_. > A GZIP of the > mysqldump is _tiny_. For our data it seems there is a lot of > repetition. I think the difference is probably that the mysqldump file doesn't contain any index data. On some of our tables the index file is bigger than the actual data file. And yeah, the dump files (and update logs!) do compress really well. The fact that they're text and contain a lot of repeated commands means they pack down quite small. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
