EQEmulator Forums - Updated Bot Backup Batch File

Here's an updated .bat file to save *all* the bot info when doing a backup
Code:
@echo off

cls

REM Change these variables to suit your setup



REM the name of your database

set db=peq



REM the ip of your MySQL server, leave as is if local

REM -h prefix is needed if remote

set ip=-h127.0.0.1



REM Your database password, leave blank to enter manually

set pass=changeme



REM the folder to backup to (created in the current folder), set to . to not create a folder

set backupdir=bot_backup

REM the name of the bot backup file to create

set backupfile=bot_npcs.sql



echo **************************************

echo ***        Backing up Bots         ***

echo **************************************

if backupdir==. goto :end

dir .\ /a:d | find /i "%backupdir%" > nul

if errorlevel 1 goto notfound

goto :end

:notfound

md %backupdir%

:end

echo *** Dumping Bots from NPC_Types... ***

mysqldump -u root -p%pass% %ip% "--where=id in (select botnpctypeid from botsowners)" -x -t %db% npc_types > %backupdir%\%backupfile%

echo *** Dumping Bot Groups...          ***

mysqldump -u root -p%pass% %ip% -x -t %db% botgroups >> %backupdir%\%backupfile%

echo *** Dumping Bot Inventory...       ***

mysqldump -u root -p%pass% %ip% -x -t %db% botinventory >> %backupdir%\%backupfile%

echo *** Dumping Bot Leader...          ***

mysqldump -u root -p%pass% %ip% -x -t %db% botleader >> %backupdir%\%backupfile%

echo *** Dumping Bots Owners...         ***

mysqldump -u root -p%pass% %ip% -x -t %db% botsowners >> %backupdir%\%backupfile%

echo ***          Done dumping!         ***

echo **************************************

echo To re-source the bots source '%backupdir%\%backupfile%'

pause