myisampackThe myisampack utility produces compressed, read-only tables. It achieves typical storage requirement reductions of 40% to 70% while maintaining fast record access. myisampack packs MyISAM tables and works with all data types. No special version of the MySQL server is needed to read tables that have been packed with myisampack. This makes them especially applicable for applications for which you want to distribute a table containing archival or encyclopedic information that is read-only and need not be updated. For example, if you are setting up a CD-ROM for an application that uses the embedded server, you'll be able to pack more data on the disk by using compressed MyISAM tables. If you want to convert a packed file back to unpacked and modifiable form, you can do so by using myisamchk --unpack. Usagemyisampack [options] tbl_name ... A tbl_name argument can be either the name of a table or the name of the index file for the table. (For MyISAM tables, index files have an extension of .MYI.) The name must include the pathname to the directory in which the table is located if you are not in that directory. myisampack packs data files but does not touch index files, so after using it, you must update the indexes by running myisamchk --recover --quick. Standard Options Supported by myisampack--character-sets-dir --help --verbose --debug --silent --version Options Specific to myisampack
|