@ferrin
send me a link to what you have..tell me where you left off, and ill work backwards from you until we meet in the center..lol
**im actually half way into "decoding" the MIR project...**
This has definitely been a learning project let me tell ya lol.
Ok, I'll tell you what i did and, hopefully it will help get you going.
We were going to sit down and attempt to write an entire schema script but
decided to give "toad for mysql" a shot at it.
For the most part it really did give us a good idea of where the biggest differences were.
Once you install Toad for Mysql (it's freeware), you create a connection to the mysql server and then pull up "tools" in the menu options at the top left and click "compare > schema compare".
This will pull up the compare wizard and ask which DB's you'd like to compare, point at your old DB in the first or the "source", then point to the new DB (MIR 3.0/Aion lightning 3.x DB) for the target.
once you have all that filled in you can click the "compare".
The columns shown will tell you how many differences it has found and where they are.
You can then go to top left menu again and find "Synchronize" under "schema compare" .
From here you can tell it to "make source like target". This will create a script that "should" make the necessary changes and mirror the two databases, but obviously it isn't perfect.
The good news is that most of the column differences are simple underscores and with navicat's design tool you can make the necessary changes pretty quick. The bad news is, that despite making all of those changes to match everything up... My old characters still do not show up in the list. Everything looks great in the DB ...but they are not showing up.