Start by setting up a new database but use a different name. Follow the same instructions you used to set up the original database just use something like "create database peqoffline;" then "use peqoffline;"
Once you've sourced in the database and updates you can dump the unmodified database to disk as a backup. from an MSDOS prompt you can type
c:/>mysqldump -uyourusername -pyourpassword peqoffline >pequnmodified.sql
That gives you an up to date copy that you can source in later (if needed) without having to apply all the updates again.
Next dump just the npc_types table so if you mess up you can drop npc_types table and source the table back in without having to do the entire database.
c:/>mysqldump -uyourusername -pyourpassword peqoffline npc_types >pequnmodified.sql
Now you can drop the second database since you have the sql files.
from a mysql console
drop database peqoffline;
now go to your main database and make a backup of that in case something goes horribly wrong. Use the same mysqldump command as above just change the database name.
Once that is done, drop the npc_types table from the mysql command prompt
drop table npc_types;
source in the unmodified table you dumped earlier.
source npctypes.sql;
THen everything should be back to the default NPCs and you can experiment away knowing you have an unmodified table backup in case anything goes wrong.
|