> -----Original Message-----
> From: Keith C. Ivey [mailto:[EMAIL PROTECTED]

> It's true that mysqldump doesn't put the data for the index itself 
> into the dump file.  That does not automatically mean that the dump 
> files will be smaller than the .MYD, .MYI, and .frm files combined.  
> The dump file will certainly be larger that the .MYD file -- perhaps 
> much larger if you have lots of non-text columns.  The difference may 
> be greater or smaller than the size of the .MYI file.  It depends on 
> your data and your indexes.  In most cases I'd say that whatever 
> difference there is isn't enough the affect the choice of backup 
> method.

I'd agree.  Disk is cheap.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to