My bot dropped when i run it! (MySQL server has gone away)

[MSSuraia]

hi , when i run my bot : php worker.php start , it's connect to the teamspeak then it's get dropped connection , and this is the log:

Initialize Bot... [done]
2016-11-12 02:07:41.135516 Check Database for updates... [done]
2016-11-12 02:07:41.135716 Connect to TS3 Server (Address: "localhost" Voice-Port: "9987" Query-Port: "10011")... [done]
2016-11-12 02:07:41.166747 Join to specified Channel... [done]
2016-11-12 02:07:41.169284 Bot starts now his work!
2016-11-12 02:07:41.287327 User [****] (unique Client-ID: a*************leSljhc8kA=; Client-database-ID 2***) is unknown -> added to the Ranksystem now.
2016-11-12 02:07:41.292739 User **** (unique Client-ID: F******************0=; Client-database-ID 2****) is unknown -> added to the Ranksystem now.
2016-11-12 02:07:41.353043 calc_user 16:Array
(
    [0] => HY000
    [1] => 2006
    [2] => MySQL server has gone away
)
1
2016-11-12 02:07:41.413854 Array
(
    [0] => HY000
    [1] => 2006
    [2] => MySQL server has gone away
)
1
2016-11-12 02:07:41.698362 get_avatars 3:Array
(
    [0] => HY000
    [1] => 2006
    [2] => MySQL server has gone away
)
1
2016-11-12 02:07:41.701890 Array
(
    [0] => HY000
    [1] => 2006
    [2] => MySQL server has gone away
)
1
2016-11-12 02:07:42.004903 update_groups 3:Array
(
    [0] => HY000
    [1] => 2006
    [2] => MySQL server has gone away
)
1
Array
(
    [0] => HY000
    [1] => 2006
    [2] => MySQL server has gone away
)

[Shad86]

looks like your msql-server has an issue or you just lost the connection to it.

Like it says:

[2] => MySQL server has gone away

i found also a stackoverflow post about that:

http://stackoverflow.com/questions/7942154/mysql-error-2006-mysql-server-has-gone-away

This could help you too i think. But please only change things when you know what you do!!!

regards

Shad86

[MSSuraia]

i will reinstall the mysql and ranksystem , put i have to do a backup to users and config table , then when i install it again i can import the backup , right?

[Shad86]

Yes that should be possible then, but before you put in your backup test it if it runs well, without the backup, just to make sure all is fine.

[MSSuraia]

i did it and has worked , thanks <3

[Shad86]

Locked issue and cleaned up conversations that not really have something to do with the issue/solution itself.