Windows House Problem

[Ceejzor]

Ok Everytime my server save's usually before it only took 1-4 second's now it is giving me this and taking 60 seconds.

Btw it's giving me like.. 100000's of these. It just started happening.

[05/03/2010 17:12:49] > Saving server...
[05/03/2010 17:12:52] mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 77 AND `world_id` = 0 - MYSQL ERROR: Table '.\server\house_lists' is marked as crashed and should be repaired (145)

 

[Diazapam]

Shutdown server, set optimize database to true, start server again and pray.

 

[Ceejzor]

Shutdown server, set optimize database to true, start server again and pray.

this?

optimizeDatabaseAtStartup = true

in config.lua if so it was already as is.

 

[Ceejzor]

One of my friend's suggested switch to linux, I don't have the money nor the smart's to do Linux

However he also said I could remove global-save and add in a !save function so player's can save there characters without giving the house problems? is this true?

Also other suggestions are appreciated rep to anyone who has a decent effort suggestion

 

[Azcarer]

Isn't Linux free?

 

[Ceejzor]

Atm I removed global save to prevent the houses from doing that bug again.
But I really don't want to keep it like this because what if server crash's and the people haven't used !save major rollback?

any solutions?

 

[Ceejzor]

~bump~

 

[Diazapam]

I'm afraid that the houses have to be imported again, that will most likely cause the players to lose their houses/house items.

 

[Cykotitan]

Just repair the table in phpMyAdmin ?

Or execute this query:

REPAIR TABLE `house_lists`;

 

[Ceejzor]

Just repair the table in phpMyAdmin ?

Or execute this query:

REPAIR TABLE `house_lists`;

Would this require the server being offline before I do it?
and would any houses be erased?