DB crashed need help!

[Aurora 46]

Hello everybody

 

I got this error

 

ChildLoop: AsyncSQL: query failed: Table './player/player' is marked as crashed and last (automatic?) repair failed (query: SELECT pid, grade, is_general, offer, level, job, name FROM guild_member, player WHERE guild_id = 408 and pid = id errno: 144)

 

Can somebody help?

 

Thanks in advance

 

-Aurora

[martysama0134 7198]

player.player must be repaired.

# mysqlcheck -r player player

NB: It could additionally require "-u root -pPASSWORD".

[Aurora 46]

player.player must be repaired.

# mysqlcheck -r player player

NB: It could additionally require "-u root -pPASSWORD".

 

I already tryed to repair it but it says 

 

"Error: table 'player' is read only"

"Status: operation failed"

 

And that is by all table in player database

[martysama0134 7198]

"Error: table 'player' is read only"

"Status: operation failed"

 

And that is by all table in player database

• Re-give the right permissions to the mysql user:

  chown -R mysql /var/db/mysql/
  chgrp -R mysql /var/db/mysql/

• Check whether the mysql user is full granted or not.
• Repair again the tables

[HosTCleaN 0]

Good evening,

Most simply, to solve this problem is to import table player, and the backup, if you or another database

Regards,
John Robert
Admin HostClean.Ro

[Great 16]

chown -R mysql:mysql /var/db/mysql/
chmod -R 777 /var/db/mysql
chmod -R 644 /var/db/mysql/*.cnf
mysqlcheck -u root -p --all-databases --auto-repair

 

[Metin2 Dev 4929]

Or you go to the player database, mark all tables and go to rightclick -> repair tables -> extended

it should work, try it and feedback please

@Cyber