echo off
cd \
echo "Copying c:\online\worldshare\output\* to c:\mysql\bin\*"
echo on
copy /Y \online\worldshare\output \mysql\bin
echo off
cd C:\mysql\bin
REM Exporting tables account, authentication, and character_
mysqldump test account > account.txt
mysqldump test authentication > authentication.txt
mysqldump test character_ > character_.txt
echo "Please Drop, Re-create, and Re-souce db.sql into database test"
echo "mysql>drop database test;"
echo "myswl>create database test;"
echo "mysql>use test"
echo "mysql>source db.sql"
echo "mysql>exit"
c:\mysql\bin\mysql.exe
Problem spot
echo "Sourceing in faction_list.txt, loot.txt, merchantlist.txt, npc_faction.txt, npc_types.txt, sawn2.txt, spawnentry.txt, and spawngroup.txt"
mysql -f test < faction_list.txt
mysql -f test < loot.txt
mysql -f test < merchantlist.txt
mysql -f test < npc_faction.txt
mysql -f test < npc_types.txt
mysql -f test < spawn2.txt
mysql -f test < spawnentry.txt
mysql -f test < spawngroup.txt
mysql -f test < account.txt
mysql -f test < authentication.txt
mysql -f test < character_.txt
echo "There test DB is now updated with your most resent EQSpawn output data from the worldshare directory"
cd \mysql\bin
|