MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Milan Kajnar Date:June 20 2001 6:29am
Subject:Problems in OPTIMIZE TABLE xxx...
View as plain text  
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


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