Re: ISD file size

[Thimble Smith]

At 23:38, 19990923, Cliff Addy wrote:
>No joy, just "ERROR: parse error near 'optimize table history' at line 1"

Sounds like you're using an older version of MySQL.  You can do something
like this:

    mysql> LOCK TABLES history READ;
    mysql> FLUSH TABLES;

Now, keep that client open so that you don't lose the lock, and in another
shell (as root), do:

    # cd /usr/local/mysql/var/DATABASE-NAME
    # isamchk -a history.ISM

Now in your first client,
    mysql> FLUSH TABLES;
    mysql> UNLOCK TABLES;

Tim