MySQL in a Nutshell, 2nd Edition

Name

myisampack

Synopsis

myisampack options /path/table[.MYI]

This utility creates compressed, read-only tables in order to reduce table sizes and to increase retrieval speed. For the table, give the path and table name. Optionally, you can include the .MYI file extension with the table name. When reading compressed tables, MySQL decompresses the data in memory. To decompress tables packed with myisampack, use myisamchk with the --unpack option.

Tables that are compressed and later decompressed should be reindexed using myisamchk.

A sample run of this utility is:

myisamchk --verbose /data/mysql/testing/courses.MYI

Here is a list of options available for this utility in alphabetical order:

--backup, -b

This option has the utility create a backup of the given table (table.OLD).

--character-sets-dir=filepath

This option specifies the directory containing the character sets the utility should use for sorting data.

--debug[=options], -# [options]

This option logs debugging information. The set of options used by default is 'd:t:o,logname'. See Table 16-1 at the end of the list of options under the mysqldump utility for an explanation of these flags and others that may be used.

--force, -f

This option forces a compressed table to be created even if the results are larger than the original, and to overwrite a temporary table (table.TMD) if it exists.

--help, -?

This option displays basic help information.

--join=table, -j table

This option instructs the utility to join the tables given into one compressed ...