EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Spell Support (https://www.eqemulator.org/forums/forumdisplay.php?f=664)
-   -   backup user accounts before update PEQ DB (https://www.eqemulator.org/forums/showthread.php?t=23510)

samplempg 08-18-2007 06:59 PM

backup user accounts before update PEQ DB
 
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

Quote:

Originally Posted by John Adams (Post 137169)
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.

:)


All times are GMT -4. The time now is 12:09 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.