On 28 Jun 2003 at 10:12, Nils Valentin wrote: > I understood that the backup done by f.e mysqldump would dump the > create statement only for the index - not the actually data fo the > index. That would make the backup option create smaller files than > lets say if you copy it 1x1 on the OS command line basis f.e with cp.
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. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
