Database Installation Step - Confused on what to do

[COLOR=rgb(51,51,51)]Hello, I’m new to setting this up and have never used any of these programs before. I’ve been successful so far following the guide.

[SIZE=24px]I’m at a dead still with the Database Installation page. The terms are fairly ambiguous to someone who barely has any idea what they’re doing. I’ve looked all over this site for a more detailed set of instructions. I’m setting up the 3.3.5a build. Could someone please explain a few of these steps in more detail? [/SIZE]

[SIZE=14px][COLOR=rgb(51,51,51)]Creating the Trinity databases in MySQL[/SIZE]

[SIZE=14px]To create the MySQL databases needed by Trinity, you need to execute the following MySQL queries:[/SIZE]

[li][SIZE=14px]For 3.3.x:[/SIZE][/li]


[li][SIZE=14px]For 6.x and 7.x:[/SIZE][/li]		[ul]


[SIZE=14px]You can perform this with a MySQL client or with the MySQL command-line interface (CLI).[/SIZE]

[SIZE=18px]>What does it mean to execute the following query? [/SIZE]

[SIZE=14px]You would need to use one MySQL root account before starting core to run one of those files (use MySQL root only to import one of those files, never run core as root or administrator).[/SIZE]

[SIZE=14px]TIP: edit those 2 files and change default password to something else for increased security (remember to edit conf files to use new password).[/SIZE]

[SIZE=20px]>What files are they referring to?[/SIZE]

[SIZE=14px]Trinity needs three databases to run at 3.3.5 branch and four for master - Auth, Characters, World and hotfixes (master only):[/SIZE]

[li][SIZE=14px]auth - holds account data - usernames, passwords, GM access, realm information, etc.[/SIZE][/li]
[li][SIZE=14px]characters - holds character data - created characters, inventory, bank items, auction house, tickets, etc.[/SIZE][/li]
[li][SIZE=14px]world - holds game-experience content such as NPCs, quests, objects, etc[/SIZE][/li]
[li][SIZE=14px]hotfixes (master only) - holds fixes not already added to the core or other official databases.[/SIZE][/li]
[SIZE=20px]>These links goes to sites that have nothing meaningful on them. Unsure what this step is all about. [/SIZE]

[SIZE=14px]Populating the MySQL Trinity databases[/SIZE]

[SIZE=14px]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). [/SIZE]

[SIZE=18px]>I put the TDB_world.sql file in the …/bin folder where worldserver.exe is. I ran it with heidiSQL and am not sure if that is all I was suppose to do? I’m assuming worldserver binary means worldserver.exe? [/SIZE]

[SIZE=14px]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.[/SIZE]

[SIZE=14px]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”.[/SIZE]

[li][SIZE=14px]Notice that the databases are not created yet. The names you set in the config will be used for the created databases.[/SIZE][/li]
[SIZE=14px]Start worldserver and press enter when it asks if you want to create databases.[/SIZE]

[SIZE=20px]>Currently worldserver.exe will immediately close when I open it, claiming the default password “yes” isn’t correct. I presume thats because I didn’t do some of the above steps.[/SIZE]

[SIZE=20px]Thanks in advance for any clarification. I’m a super noob to all this.[/SIZE]


What does it mean to execute the following query?

You’ll probably want to read this. It tells you how to run a query file in mysql:

I’m not familiar with the graphical clients, but the command line version should work the same in windows as it does in linux. Basically, you’re using the “<” symbol to read the file into the mysql client. You may also need to specify the user name and password.

What files are they referring to?

The two linked query files. You actually only need the 3.3.5 version, so it would have been clearer to say “one file”. Edit the query file you download (if you want to), then run it with mysql, the way they do in the link above, to create the database user and the databases.

I put the TDB_world.sql file in the …/bin folder where worldserver.exe is. I ran it with heidiSQL and am not sure if that is all I was suppose to do? I’m assuming worldserver binary means worldserver.exe?

Don’t run the TDB*sql file. It’s imported automatically when you run worldserver. Yes, executable files are binary files.

I’m not sure where the ‘yes’ password is coming from. The database password(s) in the configuration files and the query file you use to create the databases must be the same. Note that you don’t have to change them from the defaults. If you haven’t run the query file yet, you haven’t created the database user, so it would make sense that the program can’t gain access.

Thank you Dane!

What does it mean to execute the following query?

Okay, literally all you have to do is copy paste this text into the command prompt for mysql:

I wish the guide would've said that. I figured that out by a random guess. I feel dumb for not having figured that out sooner. As long as the TBD_world file is in the folder worldserver.exe is, after pasting that text into CMD, run worldserver.exe and it will do its thing automatically.

the guide is made for people with a minimum knowledge of the system they use.

I am at this point “Creating the Trinity databases in MySQL”. Could someone please break this down a bit more then the guide shows for making the databases.

I log into to HeidiSQL using root and password. Then what? I tried copying the 3.3.5 stuff in the link in the query tab and running it but that just gave an error that “world” already existed. Granted I have very very little knowledge and this sections starts using terms that were not used in the last sections.

Thank you in advance for any help :slight_smile:

you don’t need to create databases, core will do the job.