[Guide] How to update your repacks. And database

[c0ddingt0n]

1. Make sure that you have mysql up.
2. Then Go into Navicat and open it up.
3. Now go to Logon.(This contains all of your accounts, guilds, etc.)
4. Now Right click on Logon and Hit Dump Sql
5. Then it should have you save a file called logon.sql
6. Save that file as "Logon.sql" and save that somewhere on your computer.(Remember where you saved it at)
7. Now Install the new Repack and will say do you want to replace all the files.
8. Hit Yes to all and Let it download.
9. Now Edit the config's and such.
10. Once your done with that Open up the New Mysql.bat
11. Now Go Into Navicat and click on Logon.
12. Now Highlight all the files and stuff in logon.
13. Now Hit Delete and Yes.
14. Now that your logon is cleared out, Right click on Logon and Hit Execute Batch File.
15. Now Go To The file I told you to put on your pc.
16. Now Hit Start and let it go.
17. Once its done just restart Mysql and and start your new server up.

All the accounts you had on your last server and all characters are there.

[Jackie Moon]

Haha nice i'd give you rep but i need to spread the love before i can

WOOT

IM FIRST POST

[thegame240]

Yo, man thats very useful but i dont understand you alot so can u make a video or some screenshoot for me and the other noobs like me.

thanks !

[project anthrax]

Hey this is very helpful +rep but...if you keep your ascent db /and or world what tables do you change

[c0ddingt0n]

they dont change

[lordazhron]

So will this allow a 2.3 working database to work on 2.4?

[antid2]

nice tutorial man, much needed

[kreegoth]

Nice Explanation but what i must be missing is... If you reinstall and such how do you retain your custom NPC's and Custom spawn positions and such?...

[ccoa]

Well his method would delete all your custom stuff unless you exported the SQL files and then installed the repack. Then you could just execute the batch files (the SQL files that you exported) and you got your custom stuff back.