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

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

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

Kylroi, on 15 Dec 2013 - 3:04 PM, said:

There should be 3 different databases: auth, characters, and world. The database you were importing is specifically the world database. Obviously, with the conf file allowing that to be set, you can call it something other than world, but the other 2 databases need to be created separately with the appropriate sql files from the source tree (see /sql/create, /sql/base, and /sql/updates).

 

 

 

 

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?

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

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"

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

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?