Quote:
Originally Posted by sfisque
curious if anyone has any experience with upgrading an existing DB with a new snapshot (PEQ in this case) while trying to preserve accounts/characters/inventories. i'm thinking of upgrading from luclin-release to the still-hot-from-the-oven cvs snapshot but i dont want to lose my players toons or inventories.
any pointers or hints appreciated.
== sfisque
|
as long as you have your database up to date with the change log before you migrate the new peq sqls you should be find by starting mysql and sourcing drop_system.sql and following it up with load_system.sql. This will drop everything NOT character related. and then load the latest peq snapshot. This is how I do it about once a week or so.