List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:September 24 1999 3:44am
Subject:Re: ISD file size
View as plain text  
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
Thread
ISD file sizeCliff Addy22 Sep
Re: ISD file sizePaul DuBois22 Sep
  • Re: ISD file sizeCliff Addy24 Sep
    • Re: ISD file sizePaul DuBois24 Sep
      • Re: ISD file sizeCliff Addy24 Sep
        • Re: ISD file sizeThimble Smith24 Sep
          • Re: ISD file sizeVivek Khera24 Sep
        • Re: ISD file sizeBob Kline24 Sep
    • Re: ISD file sizeMartin Ramsch24 Sep
    • Re: ISD file sizeBob Kline24 Sep