Jump to content
TrinityCore
Sign in to follow this  
Morvis

Importing old Database

Recommended Posts

Hello. 

I just prepared TrinityCore server on Debian 9, ex. 3.3.5a, it's finally running and I wonder if there is a way to manually import few of my old tables to the newest revision.

Revision from old repack: TrinityCore rev. 02d7df6aa435 2016-04-20

When I checked creatur_template for example.. I noticed two differences there:

1) Inhabit Type column has been removed

2) spell_school_immune_mask column has been added

Is there a way to export it to an excel where I can remove and add appropiate columns, so it will be compatible? I did not find such options only classic .sql export, which would take forever to manually change it.

Best Regards

Share this post


Link to post
Share on other sites

This sounds like it would be pretty easy to do in sql. Just use alter table to add the column you're missing -- no need to delete anything. Then import without dropping the table, skipping duplicates. I think it would be harder to do in a spreadsheet.

If you're going from a repack to the official version, I'd hesitate to change any of the tables too much though. It kind of defeats the purpose.

Share this post


Link to post
Share on other sites

an other possibble solution would be to apply all missing updates, you need to find all sql updates made since TrinityCore rev. 02d7df6aa435 2016-04-20 

the old sql updates you will find here:  https://github.com/TrinityCore/TrinityCore/tree/3.3.5/sql/old/3.3.5a  
the newer here; https://github.com/TrinityCore/TrinityCore/tree/3.3.5/sql 

you yust need to concat all update sql files for your world / characters and auth db via batch / script then you can simply apply the update (if your repack had no breaking structure changes)
this way youre able to keep all your data and you will get all missing fixes from TC over time

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...