backup user accounts before update PEQ DB

[samplempg]

Help! Where can I find reference sql script for backing up all user accounts and infos before update wincvs latest PEQ DB.

[John Adams]

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]

Originally Posted by John Adams

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]

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.