EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Linux Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=588)
-   -   User migration (https://www.eqemulator.org/forums/showthread.php?t=22915)

sfisque 06-06-2007 03:44 AM

User migration
 
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 06-06-2007 04:56 PM

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.

sfisque 07-07-2007 10:39 PM

worked like a champ. thx roja :)

== sfisque


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

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