Windows Optimizing tables doesn't work..

[jnote]

Well I've been trying to set up a Ot-server.
The distro I've used is the "cryingdamson 0.3.6 (8.60) V6"

I've managed to create the database and everything, but I can't seem to optimize the tables.. So I get this message:
[01/11/2012 10:25:22] >> Starting SQL connection
[01/11/2012 10:25:22] >> Running Database Manager
[01/11/2012 10:25:23] > No tables were optimized.

But In the database it says all the tables were optimized. Anybody know what I'm doing wrong?

otserver.accounts
optimize
note
Table does not support optimize, doing recreate + ...
otserver.accounts
optimize
status
OK
otserver.account_viplist
optimize
note
Table does not support optimize, doing recreate + ...
otserver.account_viplist
optimize
status
OK
shortened..

 

[Summ]

Why sql version are you using? Sqlite or MySql?
Do you have a database called "information_schema" in your database management?

 

[jnote]

I'm using Mysql
Yeah I do have "information_schema"

 

[Summ]

I read that OPTIMIZE TABLE was remapped to ALTER TABLE table_name ENGINE = 'InnoDB';
for InnoDB tables, however you should test that first before using it on your main database, create a backup or something.

 

[jnote]

I can't find this ALTER TABLE table_name ENGINE = 'InnoDB' anywhere.. :/

And sorry for asking, but what am I supposed to do if I'd found it? xd

 

[Summ]

I meant that the function OPTIMIZE TABLE table_name; is replaced with ALTER TABLE table_name ENGINE = 'InnoDB';
However test it on a backup first if you want to optimize your tables.


Also you will get a lot of information by using google:
"Table does not support optimize, doing recreate"

 

[jnote]

I'll try that! Thank you for the answers

 

[Loney]

config.lua

startupDatabaseOptimization = true