Server Backup Help

[Esildor]

Hola,

Had to use the Navicat backup option tonight and, it's loading every single table back in perfectly fine except for "Character_"

When I try to restore it I receive this message:


[Msg] Decompressing...
[Msg] Table Created: character_
[Msg] Importing Data...
[Msg] 2006 - MySQL server has gone away
[Msg] Table Restored: character_
[Msg] Rolling back...
[Msg] Finished - Stopped before completion


Any ideas? It says MySQL server has gone away but it's connecting fine for every other table, I'm able to log into my server and also am able to login with the EoC server editing tools.

Also, in game when my toon is trying to save I'm getting this error:


Error: Asyncronous save of your character failed.
errbuf:


I assume there is something wrong with my character_ table :l?

Edit:

Looking at the debug files I think the save error has to do with the missing "Character_" table .. seeing as how everything else loaded in from my restore the inventory table etc already has values, and the character save it's trying to do is using an ID that is already saved into my DB and so I think that's what's triggering the character save fail(?).

Edit2:

So, I don't think this has anything to do with my "Character_" table issue, but, looking through my logs I noticed I've been getting the same error everytime I boot my server since I started tinkering with my server almost a month ago now, it looks like this:

File Name:

eqemu_error_queryserv_4068.log

File Contents:


[04.03. - 06:07:41] Starting Log: logs/eqemu_error_queryserv_4068.log
[04.03. - 06:07:41] Failed to connect to database: Error: #1045: Access denied for user 'root'@'localhost' (using password: YES)

[Maze_EQ]

wrong password as root user?

[Maze_EQ]

Actually, no, check your mysql permissions.

You have read, deny write'

[Esildor]

Actually, no, check your mysql permissions.

You have read, deny write'

Where can I find these permissions?

Also, do you think that's my character table problem? It was working perfectly fine before I had to restore.

Edit: If you mean user permissions in like Navicat for the database then I've got them all selected.

[Esildor]

Still can't get this character table to restore :/

[Esildor]

Tried again, and then looking at the MySQL logs this is what's being logged as it fails to restore the "character_" table:


[2014-04-04 00:49:28.921] [000002] [EQEmu] [MYSQL]
SHOW FULL TABLES WHERE Table_type != 'VIEW'

[2014-04-04 00:49:28.947] [000001] [EQEmu] [MYSQL]
SHOW DATABASES

[Esildor]

Just tried a few different backup points for the "Character_" table and none of them worked, so, I'm assuming the files aren't corrupted or something.

Figures the only post I've found online with the same exact error message is in another language :rolleyes:

[Esildor]

fml. Figured it out, had to add "max_allowed_packet=100M" to my.ini in the MySQL folder.

Thank the baby lord jesus.

Anyone know what is wrong with my queryserv stuff?

[lerxst2112]

Anyone know what is wrong with my queryserv stuff?

Best guess is you have the wrong credentials in the <qsdatabase> block in your config file.

[Esildor]

Best guess is you have the wrong credentials in the <qsdatabase> block in your config file.

Thanks Lerxst, off the top of my head I do not remember editing that. Will check it out tomorrow.

[Esildor]

That worked Lerxst. I had entered everything but the password. Thanks for the tip!