PDA

View Full Version : backup user accounts before update PEQ DB


samplempg
08-18-2007, 06:59 PM
Help! :D Where can I find reference sql script for backing up all user accounts and infos before update wincvs latest PEQ DB. :rolleyes:

John Adams
08-18-2007, 08:43 PM
You could look at the drop_users.sql (edit it, don't run it) and see the names of the tables within. Backing those up should preserve user data.

samplempg
08-19-2007, 11:58 PM
You could look at the drop_users.sql (edit it, don't run it) and see the names of the tables within. Backing those up should preserve user data.

Yeah It works great! Thank You so much :)

Dargon
08-22-2007, 03:21 PM
Just run load_system.sql it doesn't touch any of the player info. If you don't trust that just make your own batch sql file. That only changes the ones you want changed. Or even make a import.bat file that imports the sql files you tell it to.

There are easier ways than backing up the player info, then doing a full update, then restoring player info.

:)