[Tool] TrinityDB SQL Batch Installer

[dbrown1986]

TrinityDB SQL Batch Installer

I only just discovered TrinityCore + TrinityDB a few days ago, and I must say; as a team, you've really picked up the pace where MaNGOS and other emulators are lacking. Your emulator boasts more functionality than any other, and after having used it for the past four days, you can hold that boast in your own right, as long as you work as a team, brilliant things will continue to happen.

So, what is this? What does it do?

In short, when I grabbed the database from the HG the other day, I was surprised to see that the database was contained within one huge SQL file weighing in at about 80MB. Now, it's not unheard of; and most databases out there (especially the new ones) are happy with it that way. It works! That is, if you know how to import the SQL file using a command line prompt. Most people new to the private server community don't, and the surprisingly easy (to us) and yet long import syntax can be very confusing to the newcomer. So I made it easier by splitting all the tables into there own separate SQL files and scripting a batch file that will import, backup, update and install changesets automatically, ALL WITHIN 30 SECONDS ON AVERAGE! Providing you give it just a little input here and there.

Suprisingly the 50MB RAR provided here, vs. my 12MB RAR, and it installs WAAAAYYY faster, personally; if the devs want it, they can use it. Long as I get to keep rep.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Features!

• Import DB - Wipes and does a clean install of DB (MAKE SURE TO BACKUP UNLESS NEW DB!)

• Backup DB - Backs up all tables in specified world db and dumps them to the ./world_dump folder.

• Import Changesets - As I go along updating this project, I will include whatever changesets are released by TrinityDB, you'll simply need to view the 'updates' folder, and type the name (without the .sql extension) of any of the individual changesets into the console, or you can type 'all' into the console, to install all changesets, and it will install them for you. At the time of this release; the Full DB is up to date with r7925 of the TrinityCore, so no new changesets have been released as of yet.

• Update DB to TC2 r8161 - Each new release of this tool will contain the latest TrinityCore world updates, which you can choose to install if you have the proper revision in your repository.

• Dump Specific Table - If you have made changes to the database, and you would rather quickly dump one specific table into a file, then you can simply specify that table within this sub-menu, and it will dump only that specific table to the ./world_dump folder.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Useful info

• If you backup the db or a table that you have made changes to, you can save it and re-import it to a new database (perhaps a second realm) by simply dropping it in the ./trinity_world folder.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

F.A.Q.

Help! I get the message 'mysqldump: Couldn't find table: "season_linked_event"' when backing up my database, what happened?

Nothing is wrong, the installer is expecting the value in the event that you have used the "update db to 8161" feature. If you have not updated your db at all and you are still running r7925, then you may ignore this message. The file will be generated in the ./world_dump folder, but it will be emtpy.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

TODO: Get the event SQL's and include an Event Install/Uninstall feature.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

DOWNLOAD NOW!

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -