Don't forget that you can always source the default database into a different database on your machine. If you're "live" database is "peq" then create another database with "peqoffline". Once that's done and you've done all the updates etc you can do a dump and save an untouched but up to date database for emergencies.
Once that is done you can dump the untouched npc_types table, delete the npc_types from your live database then source in the untouched npc_types table.
Before I start making changes to a table I usually dump the table to disk. I also write every query into a text file so if I've done twenty changes then mess up all I have to do is drop the broken table, source in the untouched backup, then source in the text file with the successful queries to get back to where I was before I messed up. Total time lost is at most 5 minutes.
|