An User-friendly Database Download Page

I was thinking that maybe having a specific DB download page may help starting users avoid some really common errors.

The page should work this way:

  • The page could be find at trinitycore.org/d

  • The user should select the Branch (3.3.5/6.x)

  • Then may select an older DB version from a dropdown list [DEST]

  • It may even select the DB version it is using now [ORIG]

  • And finally a Download button appears that outputs directly a zipped folder with both the basic DB and the updates merged in an “updates_from_ORIG_to_DEST.sql” file.

Not sure it was clear… By the way, what do you think about that?

sounds really nice and would be comfortable, but is it really necessary? It is not that hard to manually sum up and apply the patches I think

Of course it is not, but think at db and updates, they’ve been distributed this way since the beginning. Are there any reason to not make simpler and faster things like these, which are done (manually) very frequently?

@Polaretto If you check the worldserver.conf file, you will see a couple of settings for automatically applying database patches. The steps are quite simple (even for those not compiling their own build, which I recommend they do since there is no official pre-compiled versions available) .

  • Download TrinityCore source (git pull { preferred method } / zip archive / whichever … ) * Edit the worldserver.conf, and if you didn’t compile your own, set the parameter for source folder to where TrinityCore source tree is. * Enable automatic database updates * Download (currently 6.02 from July 2015) latest build of the TDB * Import the auth and characters sql files into their respective databases from TrinityCore/sql/base * Import hotfixes and world from TDB sql files into their respective databases (inside the TDB download, not the TrinityCore source) * Start ./worldserver . Now as long as the settings / etc are all correct in worldserver, it will automatically merge new updates from that date forward from the sql patch files in the TrinityCore source that you downloaded in the first step. What I would suggest, is perhaps to include TDB in the sql path as part of the TrinityCore source tree. That would make things a bit easier than trying to load from different places, however there may be a logical reason for why the two projects remain segregated from each other.

[CODE]
###################################################################################################

UPDATE SETTINGS

Updates.EnableDatabases

Description: A mask that describes which databases shall be updated.

Following flags are available

DATABASE_LOGIN = 1, // Auth database

DATABASE_CHARACTER = 2, // Character database

DATABASE_WORLD = 4, // World database

DATABASE_HOTFIX = 8, // Hotfixes database

Default: 0 - (All Disabled)

4 - (Enable world only)

15 - (All enabled)

Updates.EnableDatabases = 15

Updates.SourcePath

Description: The path to your TrinityCore source directory.

If the path is left empty, built-in CMAKE_SOURCE_DIR is used.

Example: “…/TrinityCore”

Default: “”

Updates.SourcePath = “”

Updates.MySqlCLIPath

Description: The path to your mysql cli binary.

If the path is left empty, built-in path from cmake is used.

Example: “C:/Program Files/MySQL/MySQL Server 5.6/bin/mysql.exe”

“mysql.exe”

“/usr/bin/mysql”

Default: “”

Updates.MySqlCLIPath = “”

Updates.AutoSetup

Description: Auto populate empty databases.

Default: 1 - (Enabled)

0 - (Disabled)

Updates.AutoSetup = 1

Updates.Redundancy

Description: Perform data redundancy checks through hashing

to detect changes on sql updates and reapply it.

Default: 1 - (Enabled)

0 - (Disabled)

Updates.Redundancy = 1[/CODE]

We won’t include TDB into the Git tree since it would bloat the size even more.

Regards,
Carbenium

I TOTALLY agree with hackersrage, the autoupdate function for the core is really nice!