japtenks

Looking at the github for the cata database, to get to the make_full.db.sh it would be under then "database / MaNGOS3_Cata_Rev_2 ". So the cd path would need to be updated to match that. Under "database / MaNGOS3_Cata_Rev_3" there is a .7z file that might have the full database already created that you would use mysql -u root -p mangos < full_db.sql command for.

Wrote my own little install script with the information here and some other sites I found to install mangos one. edit the git address and svn address for the other version of mangos.

open up your favorite text editor, (gedit, vim, nano) paste that. Save it as a <file>.sh chmod +x <file>.sh then ./<file>.sh and away it goes.

#!/bin/bash

#install script for mangos one server

clear

echo "Installer script for Mangos-One"

echo "Lets get some input"

echo "Install needed packages y/n"

read line

echo "Enter directory for mangos i.e mangos-one"

read folder

echo "Enter server directory starting with a i.e /home/user/mangos-one-server"

read sfolder

echo "enter mysql root password"

read rpass

if [ "$line" = "y" ]

then

sudo apt-get install lamp-server^ build-essential automake autoconf libmysqlclient-dev libtool libssl-dev zlib1g-dev pkg-config git-core ssh cmake subversion

fi

echo "Is $folder correct y/n?"

read line

if [ "$line" = "y" ]

then

mkdir $folder && cd $folder

else

echo "Enter soure directory i.e /home/mangos-one"

read folder

mkdir $folder && cd $folder

fi

echo "Mangos Source"

git clone git://github.com/mangosone/server.git

cd ~/$folder/server

echo "ScriptDev2"

git clone git://github.com/mangosone/scripts.git src/bindings/ScriptDev2

echo "Patch ScriptDev2"

git apply src/bindings/ScriptDev2/patches/MaNGOS-One-s1368-ScriptDev2.patch

echo "About to build the server this will take a while, continue y/n"

read c

mkdir $sfolder

if [ "$c" = "y" ]

then

mkdir build

cd build

cmake ../ -DPREFIX=$sfolder

make

make install

cd ..

fi

cd ~/$folder

mkdir acid && cd acid

echo "Acid database"

svn co https://sd2-acid.svn.sourceforge.net/svnroot/sd2-acid/trunk/tbc/

cd ..

echo "Getting the Database"

git clone git://github.com/mangosone/database.git

cd ~/$folder/server/sql

echo "Installing the Database"

#Creating the databases and base structure

mysql -u root -p$rpass < create_mysql.sql

mysql -u root -p$rpass characters < characters.sql

mysql -u root -p$rpass mangos < mangos.sql

mysql -u root -p$rpass realmd < realmd.sql

#ScriptDev2 Database

echo "Installing ScriptDev2 Database"

cd ~/$folder/server/src/bindings/ScriptDev2/sql

mysql -u root -p$rpass < scriptdev2_create_database.sql

mysql -u root -p$rpass scriptdev2 < scriptdev2_create_structure_mysql.sql

mysql -u root -p$rpass scriptdev2 < scriptdev2_script_full.sql

#MaNGOS Database

echo "Installing MaNGOS Database"

cd ~/$folder/database/_tools

chmod +x make_full_db.sh

./make_full_db.sh

mysql -u root -p$rpass mangos < full_db.sql

#Acid

echo "Installing Acid 2.0.7"

cd ~/$folder/acid/tbc/2.0.7

mysql -u root -p$rpass mangos < 2.0.7_acid.sql

cd ~$sfolder

cp mangosd.conf.dist mangosd.conf

cp scritdev2.conf.dist scriptdev2.conf

cp realmd.conf.dist realmd.conf

echo "Install should be complete"

echo "Edit your realmd and mangosd config files and you should be good to go."

exit

Sorry for the wall of text.