User migration

[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

[rojadruid]

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.

[sfisque]

worked like a champ. thx roja :)

== sfisque