Problems in OPTIMIZE TABLE xxx...

2001-06-20 Thread Milan Kajnar
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

Re: Problems in OPTIMIZE TABLE xxx...

2001-06-20 Thread Sinisa Milivojevic
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

Re: Problems in OPTIMIZE TABLE xxx...

2001-06-20 Thread Paul Cadach
Hi, Milan Kajnar wrote: [skipped] I use WinZeosDB 3.3 Components in Delphi applications... This definitely looks like a bug in Zeos components. Running this command in mysql client or mysqlgui works just find. May be, at least ZeosDBO-5.2.2 works for me fine. Check http://www.zeoslib.org/