Updating old server

[khalathas]

Hey all...I've revived an older server (from around 2013 or so), which is running great. However, I'm trying to get the db schema up to date without losing character/player data. To that end, I've spun up a spare VM, and installed a fresh up to date server via Akkius' current installer (which rocks btw). I've then taken the character tables list, added the login server tables and account tables, and exported the data choosing NOT to delete/recreate tables, and just delete+insert the data itself. LOTS of incompatibilities, such as character_alternate_abilities, my old copy has a slot column, the current version does not, but has a charges column. I'm proficient enough with sql, but is there a schema update script that already exists to save me a lot of time doing this by hand?

I've also obviously got 3 year old binaries on the old server, while the new one has the newer binaries. That part's easy enough to resolve with eqemu_update.pl but it doesn't want to correct my db. Just tells me I'm good.