Bot SQL causes database restore to fail

[Congdar]

Your mysqldump command needs the -R switch to pick up the methods.
I think that method is no longer used anyway.
Get the latest sql files as some have been updated.

load_bots.sql should be:

source player_tables/botguildmembers.sql; 
source player_tables/bots.sql; 
source player_tables/botpetstatepersists.sql; 
source player_tables/botinventory.sql; 
source player_tables/botbuffs.sql; 
source player_tables/botadventuring.sql; 
source player_tables/botgroups.sql;

use this:

DROP DATABASE IF EXISTS eqtest;
CREATE DATABASE eqtest;
USE eqtest;
source peqdb_rev1265.sql;
source load_player.sql;
source load_bots.sql;

Then try your test using the -R switch with mysqldump.

[cubber]

That worked perfectly, thanks! Now I just need to fix my other issue over here http://www.eqemulator.org/forums/showthread.php?t=30809 and I will have a working server again!

[Eva Aisling]

Originally Posted by Congdar

Your mysqldump command needs the -R switch to pick up the methods.

Pardon my ignorance, but how do I do this? I am using the most recent sql files and recently had this error on my Windows server. Is there a way to fully restore my database after a failed restore? I have all my characters, but bots work improperly.