EQEmulator Forums - Database backup restore issue

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Linux Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=588)

- - Database backup restore issue (https://www.eqemulator.org/forums/showthread.php?t=30795)

Database backup restore issue

I am having an issue trying to get my db backup to restore properly. I currently ran into an issue with my latest update that cause characters to go LD when they die, when they return they end up in the same zone that they died, naked and with no corpse anywhere in the world. The server uses PEQ and has Bots enabled.

This is the error I get when I go to restore the db

ERROR 1305 (42000) at line 4923: FUNCTION eqtest.GetMobTypeByName does not exist

I have not dropped the real db yet, I am just trying to source this in to a test db I created. This has happened to me before as well when I have tried to restore the db. Any help is appreciated.

I just tested this with a clean peq rev1265 install with bots enabled. I used the following to back it up.

Code:

mysqldump -uroot -pROOTPASS --opt eq > /backup/db/eq.sql

and still get the same error when I run

Code:

mysql -u root -p -D eq < eq.sql

Code:

ERROR 1305 (42000) at line 4923: FUNCTION eq.GetMobTypeByName does not exist

Problem lies in the bot sql. If I source in a clean peq rev 1265 db then source in load_players.sql use the mysqldump command to make a backup, then delete the db and resource the backup it goes fine.

So what could be the problem with the bot sql that causes the backup import to fail?

Posted new thread on topic in bots form here: http://www.eqemulator.org/forums/sho...d=1#post185274