Ronin825 Posted February 27, 2018 Report Share Posted February 27, 2018 (edited) Hi, im in the process of building the Mysql DB for the server ( Master Branch ) on Linux Ubuntu 17.10 i am using ssh to manage the server and so i use CLI to mange the Database. I pulled the " create_mysql.sql" script from the github page by using ""wget https://raw.githubusercontent.com/TrinityCore/TrinityCore/master/sql/create/create_mysql.sql"" i launched my mysql CLI client with ":mysql -uroot -p<password>" and attempted to run the script with "@create_mysql.sql" and it returned : mysql>@create_mysql.sql ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@create_mysql.sql' at line 1 is it possible the script is broken ? or did i miss something ?.....again. Thanks for your help and input. also once i get it working, where am i suppossed to execute this script and unpack the TDB_FULL datbase. ? in ~/TrinityCore/sql/base or ~/server/bin Edited February 27, 2018 by Ronin825 Link to comment Share on other sites More sharing options...
Rochet2 Posted February 27, 2018 Report Share Posted February 27, 2018 Not sure where you found this way of executing a file by using "@create_mysql.sql", but it is not how the manual seems to say it works.https://dev.mysql.com/doc/refman/5.7/en/mysql-batch-commands.html As you may see you should be using "mysql -uroot -p<password> < create_mysql.sql" 1 Link to comment Share on other sites More sharing options...
Ronin825 Posted February 28, 2018 Author Report Share Posted February 28, 2018 its the Oracle way of calling scripts....Thanks for the correction. where shoudl i run this script tho, does it matter ? i dont think it does, but i wanna be sure Link to comment Share on other sites More sharing options...
Aokromes Posted February 28, 2018 Report Share Posted February 28, 2018 56 minutes ago, Ronin825 said: its the Oracle way of calling scripts....Thanks for the correction. where shoudl i run this script tho, does it matter ? i dont think it does, but i wanna be sure Anywhere. 1 Link to comment Share on other sites More sharing options...
Ronin825 Posted February 28, 2018 Author Report Share Posted February 28, 2018 (edited) 48 minutes ago, Aokromes said: Anywhere. Thanks, i got it working and finalised my installl. now i have to set up the client on my Windows machine. I was wondering if there was a way to only compile the connection patcher for the client since it seems to be the only thing i need to get it running. isnt there a command in the makefile like : Make connectionPatcher or something, because it seems like a hassle to build the whole core and tools if im only going to use the connection patcher. or is there somewhere i can simply download the tool ? Edited February 28, 2018 by Ronin825 Link to comment Share on other sites More sharing options...
Aokromes Posted February 28, 2018 Report Share Posted February 28, 2018 38 minutes ago, Ronin825 said: Thanks, i got it working and finalised my installl. now i have to set up the client on my Windows machine. I was wondering if there was a way to only compile the connection patcher for the client since it seems to be the only thing i need to get it running. isnt there a command in the makefile like : Make connectionPatcher or something, because it seems like a hassle to build the whole core and tools if im only going to use the connection patcher. or is there somewhere i can simply download the tool ? you can compile only tools, witch includes connection patcher. 1 Link to comment Share on other sites More sharing options...
Recommended Posts