Windows WARNING: MYSQL Lost connection, attempting to reconnect...

[president vankk]

How I fix this error:

SET GLOBAL max_allowed_packet = 16776192;

[B][COLOR="#FF0000"][21:23:11.368] > WARNING: MYSQL Lost connection, attempting to reconnect...
[/COLOR][/B][21:23:11.385] >> Running Database Manager
[21:23:14.519] > Optimizing table: account_viplist... [success]
[21:23:14.844] > Optimizing table: accounts... [success]
[21:23:15.092] > Optimizing table: ban_table... [success]
[21:23:15.429] > Optimizing table: bans... [success]
[21:23:15.570] > Optimizing table: billing... [success]
[21:23:15.875] > Optimizing table: environment_killers... [success]
[21:23:16.108] > Optimizing table: global_storage... [success]
[21:23:16.354] > Optimizing table: guild_invites... [success]
[21:23:16.633] > Optimizing table: guild_kills... [success]
[21:23:16.907] > Optimizing table: guild_ranks... [success]
[21:23:17.224] > Optimizing table: guild_wars... [success]
[21:23:17.457] > Optimizing table: guilds... [success]
[21:23:17.757] > Optimizing table: house_auctions... [success]
[21:23:18.094] > Optimizing table: house_data... [success]
[21:23:18.328] > Optimizing table: house_lists... [success]
[21:23:18.753] > Optimizing table: houses... [success]
[21:23:19.086] > Optimizing table: killers... [success]
[21:23:19.302] > Optimizing table: login_history... [success]
[21:23:19.877] > Optimizing table: market_history... [success]
[21:23:22.957] > Optimizing table: market_offers... [success]
[21:23:23.290] > Optimizing table: player_deaths... [success]
[21:23:23.707] > Optimizing table: player_depotitems... [success]
[21:23:23.948] > Optimizing table: player_inboxitems... [success]
[21:23:24.399] > Optimizing table: player_items... [success]
[21:23:24.693] > Optimizing table: player_killers... [success]
[21:23:24.998] > Optimizing table: player_namelocks... [success]
[21:23:25.407] > Optimizing table: player_skills... [success]
[21:23:25.689] > Optimizing table: player_spells... [success]
[21:23:26.026] > Optimizing table: player_statements... [success]
[21:23:26.327] > Optimizing table: player_storage... [success]
[21:23:26.978] > Optimizing table: player_viplist... [success]
[21:23:27.457] > Optimizing table: players... [success]
[21:23:27.882] > Optimizing table: reports... [success]
[21:23:28.121] > Optimizing table: server_config... [success]
[21:23:28.416] > Optimizing table: server_motd... [success]
[21:23:29.499] > Optimizing table: server_record... [success]
[21:23:30.162] > Optimizing table: server_reports... [success]
[21:23:30.614] > Optimizing table: services... [success]
[21:23:31.879] > Optimizing table: tile_items... [success]
[21:23:32.540] > Optimizing table: tile_store... [success]
[21:23:32.749] > Optimizing table: tiles... [success]
[21:23:33.078] > Optimizing table: z_changelog... [success]
[21:23:33.093] > Optimizing table: z_ots_comunication... [success]
[21:23:33.114] > Optimizing table: z_shop_offer... [success]
[21:23:33.378] > Optimizing table: z_shopguild_history_item... [success]
[21:23:33.633] > Optimizing table: z_shopguild_history_pacc... [success]
[21:23:34.420] > Optimizing table: z_shopguild_offer... [success]

I already did that >>1813464 and isn't working..

Thanks.

 

[Cronox]

are use linux ?

 

[president vankk]

@up

Windows

 

[askov]

Bump

 

[president vankk]

up.

 

[Ninja]

Are you planning to host it on Windows or is it just for testing locally?

It's not like that the server is losing connection on startup, I remember this got fixed in r57XX but not sure if someone has touched databasemysql.cpp after that change. xd

 

[president vankk]

It just a local test, xd.

Btw, I'm using the last rev, xd. I was working, but not isn't working, - Don't know why, xd.

 

[president vankk]

uppppppp!

 

[Klaien]

Try using sqlite if ur going for localhost, it's the most easiest one. Just change it in ur config.lua

 

[president vankk]

Try using sqlite if ur going for localhost, it's the most easiest one. Just change it in ur config.lua

Never used sqlite; by the way, sqlite is waste of time. I want try fix this error.