I have been working on an old trinitycore compile, creating my custom server. Now I’ve got old databases with all my custom creatures, items, etc, and when trying to move my databases to a fresh (latest update) trinitycore revision, obviously there are errors. This is because my old databases do not contain some of the tables that they should for the new version of TC, and also some of my old tables have different structures to those in the new TC. I am getting a number of ‘column not found’ errors when I start my worldserver.
Is there a way to update the structure of my database without losing any of the data? I also have some custom tables which I don’t want to lose either. Thanks guys, and I wouldn’t be posting here if it wasn’t a last resort. Any and all help is greatly appreciated.
I’m looking for a way to update the structure of my old databases. I understand what the error is saying, and it’s saying that because it’s trying to launch the worldserver with outdated databases. I can’t work out how to update the structure of my old databases. Can you point me toward a resource that will teach me how to do this? I don’t mind reading up myself, I just don’t know where to look.
And you’re right in that this is similar to my other thread, but it’s a different question. My old question was to do with the actual migration, and now that I’ve done that, my new question is concerning the updating of database structures.
That might help you.
I hope it does anyways.
Make sure you backup old work as it could nuke it or make it worse possibly.
It will only work if your db is new enough to have
Hi, I’m facing similar problems. My own installation has databases from Jan 2020(not modified). Any attempt to do automatic migration to the current build of trinity core fails, because data base structures are different. Any options to atomatically migrate databases to current version?