This article is part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. |
Before proceeding, please make sure that you have compiled your sources and they are up-to-date. |
Download the latest database compilation from TrinityCore Downloads.
Click the database release you want to download, scroll down to the bottom and you should see a link to download TDB_full_*.7z the green Download button on top right next to right column.
There are multiple .sql files to choose from in the .7z archive. If this is your first time installing TrinityCore, you will ONLY need the file with "TDB_full" at the beginning. |
Trinity needs 3 databases to run at 3.3.5 branch - Auth, Characters, and World:
From the unpacked 7z folder copy the SQL file that starts with "TDB_full_" to the directory where your worldserver.exe is.
Open your worldserver.conf, go to the "UPDATE SETTINGS" section and set the following settings:
Updates.EnableDatabases = 7 |
Also make sure you have set valid database login information and the table names you want to use in the same config file under "CONNECTIONS AND DIRECTORIES".
Start worldserver.exe and press enter when it asks if you want to create databases.
After the server seems it has started up normally then your databases are created and filled.
Both core and DB fixes will be committed to the TrinityCore repository, which you may also view in Git Extensions by following the "Fetch" instructions in Keeping the Source Up-to-Date. Pending fixes can be found on our tracker with data from the developers and contributors.
It is recommended to stay on the same revision as the TDB_full_335.*.sql (for example TDB_full_335.60_2015_11_07.sql) database (Beginner).
Note: You can run the following query on the World database to see your current DB and core revision:
SELECT * FROM `version`; |
This assumes that you have completed the previous steps of the installation guide.
Note: If you have made any custom changes to your database, you may wish to backup (export) all three of them (world, characters, and auth) before performing the next few steps.
Thanks to the automatic DB updater the single step you have to do, is to fetch a new revision (Keeping the Source Up-to-Date) and the appropriate updates will we applied at server startup.
If your world database is ever corrupted (ex. creatures or objects are accidentally deleted), it is easy to revert it back to its original state by re-importing the TDB_FULL.sql into your world database. If you updated your core using the (Advanced) instructions, make sure you also re-import all of the necessary C:\Trinity\sql\updates as explained above. |
Trinity needs 4 databases to run at 6.x branch - Auth, Characters, Hotfixes and World:
From the unpacked 7z folder copy the two SQL files that start with "TDB_full_" to the directory where your worldserver.exe is.
Open your worldserver.conf, go to the "UPDATE SETTINGS" section and set the following settings:
Updates.EnableDatabases = 15 |
Also make sure you have set valid database login information and the table names you want to use in the same config file under "CONNECTIONS AND DIRECTORIES".
Start worldserver.exe and press enter when it asks if you want to create databases.
After the server seems it has started up normally then your databases are created and filled.
Both core and DB fixes will be committed to the TrinityCore repository, which you may also view in Git Extensions by following the "Fetch" instructions in Keeping the Source Up-to-Date. Pending fixes can be found on our tracker with data from the developers and contributors.
It is recommended to stay on the same revision as the TDB_full database (Beginner).
Note: You can run the following query on the World database to see your current DB and core revision:
SELECT * FROM `version`; |
This assumes that you have completed the previous steps of the installation guide.
Note: If you have made any custom changes to your database, you may wish to backup (export) all three of them (world, characters, and auth) before performing the next few steps.
Thanks to the automatic DB updater the single step you have to do, is to fetch a new revision (Keeping the Source Up-to-Date) and the appropriate updates will we applied at server startup.
If your world database is ever corrupted (ex. creatures or objects are accidentally deleted), it is easy to revert it back to its original state by re-importing the TDB_FULL.sql into your world database. If you updated your core using the (Advanced) instructions, make sure you also re-import all of the necessary C:\Trinity\sql\updates as explained above. |
This article is part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. |