> -----Original Message----- > From: Keith C. Ivey [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 26, 2003 5:49 PM
> The dump file will be larger than the MyISAM data file for the > original table -- especially if you have many non-text columns > (dates, numbers, ENUM columns, etc.). In some cases, when you have > large indexes, the index file will be large enough that it and the > data file combined will be larger than the dump file, but in some > cases it won't be. I wouldn't consider the difference in size, > whichever way it goes, to be significant in deciding between backup > methods. FWIW, if size is a problem, mysqldump files compress quite well with gzip. (Lots of repeated text.) The same is true of update logs, if you're keeping those. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
