| Panel | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
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.
|
| Nota |
|---|
Before proceeding, please make sure that you have compiled your sources and they are up-to-date. |
Downloading the Database
Download the latest database compilation from TrinityCore Downloads (you may need to click on Next at page footer to see the proper TDB files).
- Note that there are different database compilations available for different branches of TrinityCore, for example 3.3.5 and master.
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.
- You want to download the file in .7z format - that is the database download and the others are not
- The file is in .7z format, so you will need an archive program like 7zip to unpack it.
| Advertencia | ||
|---|---|---|
| ||
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/s with the name starting by "TDB_full" on your worldserver directory (the files inside updates are made to update from older TDB revisions without having to apply every file if you have autoupdater disabled (NOT RECOMMENDED)). |
Installing The Trinity Databases
| Advertencia |
|---|
Import the content of https://github.com/TrinityCore/TrinityCore/blob/master/sql/create/create_mysql.sql (master branch) or https://github.com/TrinityCore/TrinityCore/blob/3.3.5/sql/create/create_mysql.sql (3.3.5a branch) with your favorite mysql client with root account before starting core. TIP: edit those 2 files and change default password to something else for increased security (remember to edit conf files to use new password). |
| Expandir | ||
|---|---|---|
| ||
Trinity needs 3 databases to run at 3.3.5 branch and 4 for master - Auth, Characters, World and hotfixes (master only):
|
From the unpacked 7z folder copy the SQL files that start with "TDB_world_" and "TDB_hotfixes_" (6.x branch only) to the directory where your worldserver binary is (DON'T RENAME THOSE FILES OR AUTOMATIC SETUP WILL FAIL).
NOTICE: you don't need to import any databases, only the file creating users. If you have plans to import databases manually you need to disable autoupdater on config files.
If you have plans to change default mysql usernames and passwords make sure you have set valid database login information and the table names you want to use in the same config files (authserver/bnetserver/worldserver.conf) under "CONNECTIONS AND DIRECTORIES".
- Notice that the databases are not created yet. The names you set in the config will be used for the created databases.
Start worldserver and press enter when it asks if you want to create databases.
| Info |
|---|
|
After the server has created the databases it will look for maps and vmaps, if not found it will exit.
Realmlist Table
You need to make sure that your authserver / bnetserver (6.x and >) application directs incoming connections to your realm.
- Run your chosen database management tool (ex. SQLYog or HeidiSQL, but also web-applications like Phpmyadmin for servers with php extension)*
- Open the auth database and find the realmlist table. You need to edit the
addressfield according to your needs:- LAN IP (192.168.x.x) - If you are installing TrinityCore on a different computer from where you run WoW, but all the computers involved are on the same network (router) use that computer's Local Area Network IP.
- 127.0.0.1 - Also known as "localhost". Leave this setting alone here and in your configs if you've installed TrinityCore on the same computer you run WoW on, and only you are connecting to it.
External IP – If you want other people to connect to your server, use your external IP. Visit http://www.whatismyip.com/ to find your external IP address.
| Info |
|---|
| You will need to restart your server authserver/bnetserver if you made any changes to your reamlist table. |
Keeping the DB up to date
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 Windows / Linux. Pending fixes can be found on our tracker with data from the developers and contributors.
| Expandir | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
Note: You can run the following query on the World database to see your current DB and core revision:
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 Windows / Linux) and the appropriate updates will we applied at server startup.
| Insertar extracto | ||||||
|---|---|---|---|---|---|---|
|
| Panel | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
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.
|