Computer got BSOD and now problem with sql with the server ! IMPORTANT

[Arrish]

So my computer got BSOD (blue screen of death) while my server was on , so i restarted the computer , and run the server and i got this problem in console :

MySQL ERROR mysql_real_query: SELECT `save` FROM `players` WHERE `id` = 56 Table 'players' is marked as crashed and should be repaired

> MySQL ERROR mysql_real_query: DELETE FROM `player_depotitems` WHERE `player_id` = 413 Incorrect key file for table '.\roxor\player_depotitems.MYI'; try to repair it

> MySQL ERROR mysql_real_query: SELECT `save` FROM `players` WHERE `id` = 448 Table 'players' is marked as crashed and should be repaired

so what is this and what should i do please i need help fast i give rep ´+ !!

 

[Belthazor]

repair the tables and it schuld be fine

 

[Arrish]

What do you mean tables
? , icant even go into players in database sql , so how should i fix it

 

[Belthazor]

you dont have to just go to sql database and then select all the tables and then go down and there u can chose Repair, lok at the picture there.

 

[Arrish]

THX , now i can go into players , but still this error comes:

MySQL ERROR mysql_real_query: DELETE FROM `player_depotitems` WHERE `player_id` = 7 Table '.\roxor\player_depotitems' is marked as crashed and should be repaired

> MySQL ERROR mysql_real_query: DELETE FROM `player_depotitems` WHERE `player_id` = 7 Table '.\roxor\player_depotitems' is marked as crashed and should be repaired

> MySQL ERROR mysql_real_query: DELETE FROM `player_depotitems` WHERE `player_id` = 7 Table '.\roxor\player_depotitems' is marked as crashed and should be repaired

 

[Belthazor]

you have to select all tables so you can repair all tables.

or you can do 1 by 1 table. do the same thing with all table that gives error

 

[Arrish]

Oh fixed it by a server restart, many thx to you my friend + rep!