["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

NVM it was my own stupid mistake. i didnt click run is all. everything seems fine now except my auth server.exe works fine but world does not for some reason. it just closes the moment it opens

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

Hey guy i got a problem i wonder if someone can perhaps assist me? i will really appreciate it.

im using Win7 .64

HeidieSQL win32

mysql server win32 x86

the guide im using is http://www.trinitycore.info/How-to:Win to set up my server

when i import my databases intothe auth and characters database's they are still empty (attached pic). tried refreshing. it doesnt even give me the Run file(s) directly option. importing the world database using the TDB_full_335.11.46_2012_02_13.sql file it works fine it seems. i followed the guide and used C:\Trinity\sql\base\auth_database.sql and C:\Trinity\sql\base\character_database.sql. but even after refreshing it seems both db's are empty and as a result when i run the authserver.exe and worldserver.exe they close a second after they open.

also one more thing in the guide when setting up your server and opening the config files it says scroll down to LoginDatabaseInfo = "127.0.0.1;3306;trinity;trinity;auth". when changing all these to match mysql database login info i change the "trinity" "trinity" to what ever my sql root and password was correct? just want to make sure. sorry for asking stupid questions again

Regards

Bross

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

cool. thanks. i can connect to the database fine now. i got a different problem now though. when i import my databases from into the SQL database the auth and characters database is empty. tried refreshing. it doesnt even give me the Run file(s) directly option. importing the world database using the TDB full file works fine it seems. i followed the guide and used C:Trinitysqlbaseauth_database.sql and C:Trinitysqlbasecharacter_database.sql. but even after refreshing it seems both db's are empty and as a result when i run the authserver.exe and worldserver.exe they close a second after they open.

also one more thing in the guide it says scroll down to LoginDatabaseInfo = "127.0.0.1;3306;trinity;trinity;auth". when changing all these to match mysql databse login info i change the "trinity" "trinity" to what ever my sql root and password was correct? just want to make sure. sorry for asking stupid questions again

Bross

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

Thanks a lot for the help guys. really appreciate it. haha Winblows will be the end of me i swear

ok it seems to have installed properly this time. baby steps. thanks again for the help

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

Hey guys im Using windows 7 x64

Visual C++ 2010 Express x86

HeidiSQL

im using the guide http://www.trinitycore.info/How-to:Win to build my server as i would love to start learning how the databases work and how scripting works.

i got up to Installing The Trinity Databases on the guide.

my first question is in the mysql server there are 3 databases by default: sql, Information_schema and test. do i need these 3? secondly how do i import the other 3 databases using the C:\Trinity\sql\create\create_mysql.sql

could i just not manually create the 3 databases among the default SQL DB and information_schema DB and then import the 3 DB's structures by importing character_database.sql, auth_database.sql and "TDB_full" .sql respectfully.

also i might have broken the sql server by accidentally deleting the default sql database and now when i try reinstall mySQL server it freezes when it tries to start the windows service. im sorry if my questions are stupid i tried my best to sound like i know what im talking about haha.

please be patient with me if possible

thanks for your time.

Bross