TrinityCore : TDB 4.3.4 + DB Updates

• 1. Populating World database
• 2. Updating
• 3. Populating Character and Auth database
• 4. Configuring The Server

1. Populating World database

 Fresh start

1. Clone DB repository

   git clone https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha.git

2. Download most recent world database from http://www.trinitycore.org/f/files/file/9-tdb-full-434/.
3. Unpack the file and import it to your MySQL server.
4. Run merge_windows.bat if you are on Windows or merge_linux.sh if you are on Linux (these files are found in the /tools/ directory of the DB repository).
   • This will import the needed SQL update files, found in updates directory.

2. Updating

1. Update DB repository.

   git pull --rebase origin

2. Import the SQL update files from updates directory that are new since last update.
   • That means you should take note of the last SQL you imported each batch of updates
3. If a new full DB has been released, you got two options:

• Drop world database and import full new DB

          If you are updating from older versions:

• Import the new SQL files in updates and the needed files under old/updates_xx.
NOTE: don't import all files under old if you are updating from older TDBs, only the ones over your latest update.
For example, if you have clean TDB 4.3.4-4 and you are looking to update to TDB 4.3.4-5 + updates you will need to apply all the files on updates_04, all the files on updates and none on old/updates_01 to old/updates_03.
If you have one random commit between 4.3.4-4 and 4.3.4-5 you need to know witch is and apply any updates from that commit to head.

git checkout 12345example

3. Populating Character and Auth database

The process is the same used for TC master branch: all the required SQL files are in TrinityCore repository:

• /sql/base/characters_database.sql
• /sql/base/auth_database.sql

Like on master branch you never must apply sql updates for characters and auth databases when creating a new server.

If you still have problems, read http://www.trinitycore.org/f/topic/328-unknown-column-missing-table-duplicate-column-error-sql-problems-sqldriverlogfile-answer-on-1st-post-of-1st-page/

4. Configuring The Server

This page shows you how to configure the server: Configuring The Server