MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Sinisa Milivojevic Date:June 20 2001 10:54am
Subject:Re: Problems in OPTIMIZE TABLE xxx...
View as plain text  
Milan Kajnar wrote:

>Hello..
>
>I need help in this:
>
>When I use this query on my DB:
>
>"OPTIMIZE TABLE xxx..." - all look fine... but when I want optimize next
>table I get this error message from MySQL server:  Command Out of Sync - You
>cannot run this command now....
>
>When I disconnect and connect my DB again all is all right and I can
>OPTIMIZE next table....
>Exists some better way for Sync?
>
>I use WinZeosDB 3.3 Components in Delphi applications...
>
>Thanks for advices.
>
>Milan
>
>
Hi!

This definitely looks like a bug in Zeos components. Running this 
command in mysql client or mysqlgui works just find.

You should write to Zeos authors.

-- 

Regards,

--
For technical support contracts, go to https://order.mysql.com/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <sinisa@stripped>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
       <___/   www.mysql.com



Thread
Testing MySQL 4.0Sasha Pachev20 Jun
  • Re: Testing MySQL 4.0Russell E Glaue20 Jun
    • Re: Testing MySQL 4.0Sasha Pachev20 Jun
      • Re: Testing MySQL 4.0Michael Widenius20 Jun
        • Re: Testing MySQL 4.0Russell E Glaue20 Jun
        • Re: Testing MySQL 4.0Sasha Pachev20 Jun
    • Problems in OPTIMIZE TABLE xxx...Milan Kajnar20 Jun
    • Re: Problems in OPTIMIZE TABLE xxx...Sinisa Milivojevic20 Jun
    • Re: Problems in OPTIMIZE TABLE xxx...Paul Cadach20 Jun
  • Re: Testing MySQL 4.0Tibor Simko9 Jul
    • Re: Testing MySQL 4.0Sasha Pachev9 Jul