Random SQL Database Crash (TFS)

[Dark Warrior]

[SOLVED] Random SQL Database Crash (TFS)

Ye as the title say yesterday Random sql database crash leme explain what happened, this night i was getting the bug named Memory Leak if im not wrong and that murning when i was going to turn on the server BUM Players_Skills is crashed so i said alright that probb was why i got the max skill on my gm so i just tryed to finde my gm on phpmyadmin but all was alright so i decide replace the players_skills with a new one, so the players said np it's allright and then i was starting up the server again POFFFF the table of player_items are crashed too.... it's really annoying anyway heres the players_items
and player_skills
the id of the player at player_items crashed is 37....If you can tell me how to prevent that random crash ill be really thanksful
http://rapidshare.com/files/97532923/Errores.rar.html

 

[ntmr]

What you mean when you say "database crashed"?

Data missing?

 

[Dark Warrior]

What you mean when you say "database crashed"?

Data missing?

emm how i can explain you my english is bad xd anyway i will try... i mean like in the exe that says the id of the user have an error on skills and player_items and wont load it when the user log in he log with no items in other words hes items wont save same as hes skills....

omg i can't belive this now acc table is crashed too :S!!!!

 

[Mark]

Enter your database in phpMyAdmin and it should tell you which tables has crashed and ask if you want to repair them.

 

[Doonrak]

Also recommend to make a SQL database backup every day. You have special cronjobs for these things.

 

[Dark Warrior]

Enter your database in phpMyAdmin and it should tell you which tables has crashed and ask if you want to repair them.

Omg man i love you xDDD you saved my server I LOVE YOU!!! (Im not gay) lol and srry about sending you the pm

Solved close this thread!!

 

[slaw]

#Every day? I'm making every HOUR!

 

[ntmr]

I never done it on my server u.u

You need to optimize your mysql server to use InnoDB databases, that is a lot more consistent than MyISAM.