Zoning = Items Deleted

[Jibbatwinkers]

Hey, was wandering if anyone could help me with a problem I ran into. I was running my server (Zebuxoruk) and the power went out. Got it all back up and was going fine, then when I zoned my items were deleted. Same with a few other players on my server. I'm assuming the zone server and the DB aren't speaking to eachother anymore.

Someone on my server said this has happened on other servers and it's fairly easy to fix, I can't get it to work was curious if anyone knew. The Zebuxoruk Server thanks you in advance!

Edit: Found something, not sure what this means but I know it's wrong. SQL DB Reports:

Error

SQL query: DocumentationEdit

SELECT COUNT( * ) AS num
FROM `eq`.`inventory`

MySQL said: Documentation
#1016 - Can't open file: 'inventory.MYI'. (errno: 145)

[Scorpious2k]

Originally Posted by Jibbatwinkers

Hey, was wandering if anyone could help me with a problem I ran into. I was running my server (Zebuxoruk) and the power went out. Got it all back up and was going fine, then when I zoned my items were deleted. Same with a few other players on my server. I'm assuming the zone server and the DB aren't speaking to eachother anymore.

Someone on my server said this has happened on other servers and it's fairly easy to fix, I can't get it to work was curious if anyone knew. The Zebuxoruk Server thanks you in advance!

Edit: Found something, not sure what this means but I know it's wrong. SQL DB Reports:

Error

SQL query: DocumentationEdit

SELECT COUNT( * ) AS num
FROM `eq`.`inventory`

MySQL said: Documentation
#1016 - Can't open file: 'inventory.MYI'. (errno: 145)

You may have a broken table or tables. Try repairing them.

[Jibbatwinkers]

Not really sure how to repair, GM that usually does SQL is asleep, I've worked with it though so I wouldn't be lost if someone told me how to do it.

[Jibbatwinkers]

Alright just typed this in my SQL Query:

repair table inventory;

and we have ourselves a fix. Thanks for the suggestion.

[Scorpious2k]

Originally Posted by Jibbatwinkers

Alright just typed this in my SQL Query:

repair table inventory;

and we have ourselves a fix. Thanks for the suggestion.

Glad to help.