kavex

ok ok I just want to make sure i'm doing this correct 1. Import TrinityCore-TrinityCore-f1a82a5/sql/create/create_mysql.sql 2. Import TrinityCore-TrinityCore-f1a82a5/sql/base/auth_database.sql to the auth database 3. Import TrinityCore-TrinityCore-f1a82a5/sql/base/characters_database.sql to the characters database 4. Import TDB_full_335.52_2013_07_17.sql to the world database 5. Install the updates from TrinityCore-TrinityCore-e90a7f8/sqlupdates to their databases one at a time? I'm guessing since I'm using TDB_full_335.52_2013_07_17.sql for my world I don't need to install the update only that comes with it Link to a DB installer for linux installer

I figured that out after awhile Ok I was reading this http://www.trinitycore.org/f/topic/1518-trouble-with-your-trinity-install-readme-1st-faqs/?p=42704 If I install TDB_full_335.52_2013_07_17.sql do I have to install the updates as well? I looked in the update folder for the world and there is like a million of them? Do I do them all?

Ok so I imported the TDB_full_335.52_2013_07_17.sql via the terminal into a database called wow mysql -u root -p wow </home/root/server/sql/db.sql When I run ./worldserver Using configuration file /home/root/server/etc/worldserver.conf. Using SSL version: OpenSSL 1.0.1 14 Mar 2012 (library: OpenSSL 1.0.1 14 Mar 2012) Using ACE version: 6.0.3 TrinityCore rev. dcfbe53552b0 2013-12-14 20:22:39 -0330 (master branch) (Unix, Release) (worldserver-daemon) <Ctrl-C> to stop. ______ __ /__ _ __ __/ __ /_/ / _ __ /_ ___ /_ , _ __ __ /`'__/ /' _ `/ / / / / / / _ _ _ _ _ _ _ _ __/`____ /_//_/ /_//_//_//_//__/ `/___/> C O R E /___/ http://TrinityCore.org /__/ In mysql_stmt_prepare() id: 53, sql: "SELECT name, permission, help FROM command" Unknown column 'permission' in 'field list' DatabasePool wow NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Cannot connect to world database 127.0.0.1;3306;xxxxxx;xxxxxx;wow when I run ./authserver I fixed this issue by making a datebase from the base sql file I'm a bit confused what I did wrong worldserver.conf LoginDatabaseInfo = "127.0.0.1;3306;xxxxx;xxxxx;auth" WorldDatabaseInfo = "127.0.0.1;3306;xxxxx;xxxxx;wow" CharacterDatabaseInfo = "127.0.0.1;3306;xxxxx;xxxxx;characters" authserver.conf LoginDatabaseInfo = "127.0.0.1;3306;xxxxx;xxxxx;auth"

So I got the sql file TDB_full_335.52_2013_07_17 and when I go into phpmyadmin and import it. It will say SQL query: -- -- Table structure for table `access_requirement` -- DROP TABLE IF EXISTS `access_requirement` ; MySQL said: #1046 - No database selected I am using mysql 5.5.35 I've tried installing the databases separate by using the base sql files that comes with trinitycore but it is missing the world sql. Can anyone help me?