> -----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]