Jump to content
TrinityCore
Polaretto

An User-friendly Database Download Page

Recommended Posts

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?

  • Upvote 1

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

###################################################################################################
# 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
Edited by hackersrage
  • Upvote 1

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...