eKoIce Posted April 14, 2008 Posted April 14, 2008 I will try to make here a guide how to upgrade without loosing any data like chars items, skills etc. If it's not useful and someone knows a better way, feel free to correct, it will be for the good of the entire community, I think... 1. Make sure you have a working database of your new rev installed on MySQL (preferable a separate PC / laptop) 2. Work all of your new rev files just like being a full new release and you had none before (config, data, new NPC's, etc.) 3. Start login server and game server to make sure it's really working without errors 4. If everything is OK, dump your database to an SQL file ...and now for the "complicated" part... 5. If you had that on a separate PC, copy new rev on your server machine, along with your dumped SQL file 6. Make a separate DB on your server MySQL connection, like l2clean or whatever :) 7. Make sure you have altered server.properties and login.properties to match your internal / external IP 8. Stop your server (nasty !!!) 9. Go on Navicat to Tools -> Structure Syncronization 10. Left side -> (your connection name) -> (your new rev db) 11. Right side -> (your connection name) -> (your GS db) 12. Press "Compare" button 13. After compare has been done -> press "Run query" button 14. After successful completion go to Tools -> Data Syncronization 15. Left side -> (your connection name) -> (your GS db) 16. Right side -> (your connection name) -> (your new rev db) 17. Go "Advanced" and remove the mark from "Delete records" Remark: BE SURE YOU REMOVED THAT MARK BEFORE STARTING !!! 18. Press "Preview" button You will get 6 or 7 errors, tables which you should copy to a temporary DB FROM YOUR NEW REV DB and copy back after completion... Normally this tables are: boxaccess clan_wars pledge_skill_trees posts skill_spellbooks topic zone 19. If on "Preview" is everything OK then press "Start" to upgrade BE SURE YOU HAVE COMPLETED POINT 17 BEFORE !!! 20. Now just dump SQL file of your old DB and copy your new DB instead 21. start your login server 22. start your game server 23. YOU'RE DONE !!!!! It will take you longer in the first instance, with time will take less and less. I do not want to be a big mouth but now, after 6 month, it's taking me about 10 minutes top... Credits to NoobLady (Ragezone) Quote
Frank Posted April 14, 2008 Posted April 14, 2008 Nice guide man! Really usefull! Keep on! I like your style ;) Quote
Sh@d0w Posted April 14, 2008 Posted April 14, 2008 Your guide is very usefull... Thanks for sharing!!! Quote
fdLP. Posted April 14, 2008 Posted April 14, 2008 Very Usefull !! Great Guide ! As you said xxrxx its A-Style! :P --->> A Style To You!! Quote
bourbouli8ras Posted April 16, 2008 Posted April 16, 2008 very good guide,and i was wondering how i can do that. Quote
DreaM Posted April 16, 2008 Posted April 16, 2008 LOL easy, understoodable guide amd total ownage ... you deserve another karma for your amazing shares these days. Quote
Delete Posted April 16, 2008 Posted April 16, 2008 I always used the database instaler to install sql updates... is it bad to use dbinstaler? Quote
Stefoulis15 Posted April 16, 2008 Posted April 16, 2008 Nice Guide / Share Eko Thanks! Very Usefull.. P.S: Someone +1 Karma Him!!! :P Quote
motili Posted May 8, 2008 Posted May 8, 2008 Very good guide.For this im looking.Thx for Share! Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.