TrinityCore create_mysql.sql

The following steps are done using your database management program (ex. HeidiSQL or SQLYog)

1.Create the three databases by importing C:\Trinity\sql\create\create_mysql.sql. You now have three databases - auth, characters, and world.

Installing The Trinity Databases
Trinity needs [three databases] to run:

auth - holds accounts data.
characters - holds characters data.
world - holds game-experience content such as spawns, stats, quests, etc.
Note:  The auth database was previously named realmd.  If you are having trouble and searching the forum for solutions, any reference to the realmd database now refers to the auth database.

The following steps are done using your database management program (ex. HeidiSQL or SQLYog)

1.Create the three databases by importing C:\Trinity\sql\create\create_mysql.sql. You now have three databases - auth, characters, and world.
2.Import auth database structure by importing C:\Trinity\sql\base\auth_database.sql to the auth DB.
3.Import characters database structure by importing C:\Trinity\sql\base\character_database.sql to the characters DB.
4.Unrar C:\TDB\TDB_335.11.37_2011_02_11.rar and import world DB structure and contents by importing TDB_335.11.37_2011_02_11.sql to the world DB.
Now your world DB structure is for TrinityCore Revision 11201. It is imperative that you also import additional .SQL updates after completing [Keeping The Code Up To Date]. To do this, follow these steps after each update:

http://www.trinitycore.org/w/How-to:Win#Keeping_the_code_up_to_date