Navicat tables

[metallinacho]

Yellow....well im kinda newbish i have my own server just to try stuff...and i wanted to know if once u guys get done with the final part...would i be able to move some of my old navicat tables into the newer version...lets say..custom npcs...spawnlist blah blah...or it wont be compatible with the newer version???

thx!!

[Bloodshed]

to update that these files are included when they change something in the tables

http://www.l2jdp.com/trac/browser/trunk ... ql/updates

[metallinacho]

to update that these files are included when they change something in the tables

http://www.l2jdp.com/trac/browser/trunk ... ql/updates

yeah but im talkin about my custom tables not the original navicat tables

[theonn]

whats a navicat table?


seriusly? what? a mysql table? wtf?

[metallinacho]

whats a navicat table?


seriusly? what? a mysql table? wtf?

yap another useful post....i think everyone with a lil bit of common sense understands that by navicat table i meant mysql tables...so...do u know the answer??

[toastgodsupreme]

Yes, I've done a few migrations. One (repeated a few different ways to find a method I liked) with some VERY old tables on a test server, and just now with the last tables that were released for CT2.2.

Everyone will have their own preferred method of doing this. My preferred method is this (this provides me with redundancy and an escape plan if I need to jump back to CT2.2, you do not need to make a new DB, but like I said, if shit hits the fan, I want the ability to jump back to CT2.2 without hassle)...
(btw, using navicat in Windows)

• Make a complete backup of your database (duh, but really you should at LEAST have automated nightly backups).
• Create a new database. I named mine "gracia_final".
• Right click on the old database and go to data transfer.
• Transfer directly to server and select the new gracia_final database as the destination. This will basically copy your old database to the newly named database. Before doing this, make sure you change your mysql settings and tweak them if needed. There's a few settings which only take effect when you create tables for the first time, so if you're going to use those settings, now is the time to do it before you make this copy. Saves you time later.
• After copying the old database to the gracia_final one, you'll need to modify the server properties files for the login server and the game server so they point to the new gracia_final DB.
• Once that's done, run the database installer tool and choose UPGRADE and make sure you read what you choose (I am assuming you'll have the CT2.3 datapack installed with the CT2.3 sql files).
• After it's done upgrading, run the update scripts in the SQL folder. You only need to run 20090424update.sql and any ones that are dated after that. Don't be a retard and run JUST that one, run that one and all the ones dated AFTER it. I don't want to see someone coming back in QQ'ing just because they couldn't follow instructions.
• And that should be it.

Honestly, a part of me really doesn't want to give people a walk through on how to do this because it's so retardedly easy to do and I'm merely helping those who can't bother learning for themselves (and who probably can't run a proper server to save their lives). On the other hand, I'm bored and waiting for some stuff to update. So yeah... lucky you.

[DrHouse]

Thanks for the tutorial, toastgodsupreme, maybe we can stick this

[toastgodsupreme]

Thanks for the tutorial, toastgodsupreme, maybe we can stick this

One thing I should mention is that after you've done all this, it may be a good idea to go back and install a few tables by hand. I had noticed that the upgrade option didn't seem to upgrade my teleport table for some reason (was missing the latest airship teleport for example).

So I went through after all of this and ran a few of the SQL batch files by hand. Just a little warning to those who go by this method.