I have a proplem with My MYSQL

[Beru 0]

Version of MYSQL : 5.5

Hello

i have an proplem with my mysql

 

i have proplem in mysql that MYD MYI deleting its self and frm stay .. its have phased me for player.player table player.quest and player.item

 

there is no syserr

 

 

Thanks, Sincerly,
George

 

Edited August 2, 2020 by George

[tierrilopes 508]

You wanted to restart your server and you rebooted freebsd like you seen in the tutorials ?

An advice, use your serverfiles close and start scripts from now on to avoid such issues, no need to reboot freebsd at all.

 

 

[Beru 0]

Yeah but now the proplem not from the reboot ...

[tierrilopes 508]

Is it a live or a test server?

Have you tried the repair function?

 

 

[DrTurk 139]

once you repaired everything change the tables form InnoDB to MyISAM

[WeedHex 661]

Maybe it's because you do shit backups.

[DrTurk 139]

4 minutes ago, WeedHex said:

Maybe it's because you do shit backups.

packing mysql as tar.gz you say?

[WeedHex 661]

49 minutes ago, DrTurk said:

packing mysql as tar.gz you say?

yes..yes.. I saw lot of shits!

Use dump

[Beru 0]

5 hours ago, DrTurk said:

once you repaired everything change the tables form InnoDB to MyISAM

thank u

Edited August 2, 2020 by George