Versiones comparadas

Clave

  • Se ha añadido esta línea.
  • Se ha eliminado esta línea.
  • El formato se ha cambiado.
Panel
borderColor#3399cc
bgColor#DCF1FC
titleColor#FFFFFF
titleBGColor#3399cc
borderStylesolid
titleGuide

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.

Sección
Columna

<< Step 2: Core Installation

Columna

Step 4: Server Setup >>

Nota

Before proceeding, please make sure that you have compiled your sources and they are up-to-date.

Getting Started with Trinity Database (TDB)

Since this commit we introduced a new and automatic way of installing and keeping the databases up-to-date.

This is described in more detail in the following instructions.

Panel
borderColor#BBB
bgColor#F0F0F0
borderStylesolid

Contents

Tabla de contenidos
maxLevel2

Downloading the Database

Download the latest database compilation from TrinityCore Downloads.

Click the green Download button on top right next to right column.

The file is in .7z format, so you will need an archive program like 7zip to unpack it.


Advertencia
titleImportant

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.

Installing The Trinity Databases

3.3.5

Trinity needs 3 databases to run at 3.3.5 branch - AuthCharacters, and World:

Panel

auth - holds account data - usernames, passwords, GM access, realm information, etc.

characters - holds character data - created characters, inventory, bank items, auction house, tickets, etc.

world - holds game-experience content such as NPCs, quests, objects, etc.

Open your worldserver.conf,  go to the "UPDATE SETTINGS" section and set the following settings:

Bloque de código
Updates.EnableDatabases = 7

Copy the file starting with "TDB_full_" to the directory where your worldserver.exe is. Follow the next steps of the guide and at the first start of the server the databases will be set-up automatically.

Advertencia

Do NOT start the worldserver yet. Follow the next steps of the guide first.

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. 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:

Bloque de código
languagesql
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.

 

Sugerencia
titlePro Tip

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.

6.x

Trinity needs 4 databases to run at 6.x branch - Auth, Characters, Hotfixes and World:

Panel

auth - holds account data - usernames, passwords, GM access, realm information, etc.

characters - holds character data - created characters, inventory, bank items, auction house, tickets, etc.

world - holds game-experience content such as NPCs, quests, objects, etc.

hotfixes - holds fixes not already added to the core or other official databases.

Open your worldserver.conf,  go to the "UPDATE SETTINGS" section and set the following settings:

Bloque de código
Updates.EnableDatabases = 15
Copy the two files starting with "TDB_full_" to the directory where your worldserver.exe is. Follow the next steps of the guide and at the first start of the server the databases will be set-up automatically.
Advertencia

Do NOT start the worldserver yet. Follow the next steps of the guide first.

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. 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:

Bloque de código
languagesql
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.

Sugerencia
titlePro Tip

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.

 

Insertar extracto
_Installation Helper
_Installation Helper
nopaneltrue

 

Panel
borderColor#3399cc
bgColor#DCF1FC
titleColor#FFFFFF
titleBGColor#3399cc
borderStylesolid
titleGuide

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.

Sección
Columna

<< Step 2: Core Installation

Columna

Step 4: Server Setup >>