MangosZero Install - Debian - Revision history

Cfaulkner at 04:14, 21 November 2014

2014-11-21T04:14:24Z

← Older revision		Revision as of 23:14, 20 November 2014
Line 54:		Line 54:
	deb http://http.debian.net/debian wheezy-updates main		deb http://http.debian.net/debian wheezy-updates main
	deb-src http://http.debian.net/debian wheezy-updates main		deb-src http://http.debian.net/debian wheezy-updates main
			</pre>

			run sudo apt-get update

	~~deb http://security.debian.org/ wheezy/updates main~~		to update the repos
	~~deb-src http://security.debian.org/ wheezy/updates main~~
	~~</pre>~~

	=== Installing the Development headers ===		=== Installing the Development headers ===
Line 68:		Line 69:

	<pre>		<pre>
	sudo apt-get install -y ~~libace~~-~~dev libbz2~~-~~dev libmysqlclient~~-~~dev libncurses5-dev libreadline-dev libssl-dev zlib1g-dev~~		sudo apt-get install -y mysql-server mysql-common mysql-client
	</pre>		</pre>

Cfaulkner at 09:22, 20 November 2014

2014-11-20T09:22:50Z

@@ Line 202: / Line 202: @@
 cp offmesh.txt[WoW DIR]
 </pre>
 == Inserting Database Information ==

Cfaulkner at 09:18, 20 November 2014

2014-11-20T09:18:03Z

New page

This howto will be on how to get MangosZero running on Debian in VirtualBox as Windows 7 64 Bit as the host

== Installing VirtualBox ==
This part should be self-explanatory, I may recap on certain settings like BIOS and other default settings

== Starting up Virtual box and Installing the base operating system ==

Create a new virtual machine, I'm going with a 64-bit install with Debian 7.2.0 ISOs. 512MB ram, create a 20GB dynamic partition. After the new virtual machine has been set up, give the server 12MB of video ram which is more than enough to run a server.

Start the server, and select your settings as you wish.

When installing packages, only install what you need because we want this server to be as trim as possible. No Desktop, XWindow or gui, just a straight server.

On the Software Selection screen, Unselect Everything but the standard system utilities.

Install the Grub boot loader

== Setting up Build Environment for Mangos ==

Login as root, we need to install a few things first. After looking at top, I only have 58 processes total running and about 56k of RAM used. not bad at all. We want the OS to be as trim as possible, that is one of the goals for this article.

As root, type in:
<pre>
apt-get install sudo ssh
</pre>

After install of sudo, Add the user mangos and edit the /etc/sudoers file and add the mangos username

<pre>
adduser mangos

edit /etc/sudoers

Add under 'User Privilege Section' underneath root
mangos ALL=(ALL:ALL) ALL

Exit and save
</pre>

Now type in exit and login as mangos username. You should have sudo rights now.

Type in these commands to establish a build environment
<pre>
sudo apt-get install -y autoconf automake clang cmake gcc g++ libtool make patch
sudo apt-get install -y cmake-curses-gui git-core
</pre>

I had an issue with these commands not being found so I had to add the default repos in /etc/apt/sources.list

<pre>
deb http://http.debian.net/debian wheezy main
deb-src http://http.debian.net/debian wheezy main

deb http://http.debian.net/debian wheezy-updates main
deb-src http://http.debian.net/debian wheezy-updates main

deb http://security.debian.org/ wheezy/updates main
deb-src http://security.debian.org/ wheezy/updates main
</pre>

=== Installing the Development headers ===

<pre>
sudo apt-get install -y libace-dev libbz2-dev libmysqlclient-dev libncurses5-dev libreadline-dev libssl-dev zlib1g-dev
</pre>

== Installing the Database Server (MySQL) ==

<pre>
sudo apt-get install -y libace-dev libbz2-dev libmysqlclient-dev libncurses5-dev libreadline-dev libssl-dev zlib1g-dev
</pre>

Set the root password for the MySQL server

=== Creating and Setting Permissions for MySQL User ===

<pre>
mysql -u root -p

CREATE USER 'mangos'@'localhost' IDENTIFIED BY 'password';
</pre>
for Password, use whatever you want and for user mangos, use whatever you want.

<pre>
GRANT ALL PRIVILEGES ON `mangos\_%` . * TO 'mangos'@'localhost';
GRANT USAGE ON * . * TO 'mangos'@'localhost' IDENTIFIED BY 'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
</pre>
again for username and password, use whatever you want, just ensure they match

=== Creating the Mangos Databases ===

<pre>
mysql -u root -p

CREATE DATABASE `mZero_characters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `mZero_realm` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `mZero_scripts` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `mZero_world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
FLUSH PRIVILEGES ;
</pre>

== Downloading the Mangos-Zero Source from github and compiling ==

While you are in user mode and not root, create the mangos source directory
<pre>
cd ~
mkdir mangos-source
cd mangos-source
git clone --recursive -b Rel20 https://github.com/mangoszero/server
git clone --recursive -b Rel20 https://github.com/mangoszero/database
</pre>

Be sure to use the '''--recursive''' so git will pull in everything, without this your compile will fail

=== Compiling Mangos ===
create the directories needed for build
<pre>
sudo mkdir -p /opt/mZero/
sudo mkdir -p /opt/mZero/logs/mangos-zero/
sudo mkdir -p /opt/mZero/share/mangos-zero/
sudo chown -R mangos:mangos mZero
</pre>

<pre>
cd server
mkdir _build
cd _build
cmake -DCMAKE_INSTALL_PREFIX=/opt/mZero2 -DDEBUG=1 -DBUILD_TOOLS=1 -DACE_USE_EXTERNAL=1 ..
</pre>

DACE_USE_EXTERNAL=1 is important for the Tools to compile

Now in the ~/mangos-source/server/_build directory

<pre>
make
</pre>

After a successful compile run this.

<pre>
make install
</pre>

== Configuration of Mangos ==

<pre>
cd /opt/mZero/etc
cp ahbot.conf.dist ahbot.conf
cp mangosd.conf.dist mangosd.conf
cp realmd.conf.dist realmd.conf
</pre>

<pre>
nano realmd.conf
</pre>

The '''LoginDatabaseInfo''' Variable looks like this
<pre>
LoginDatabaseInfo = "127.0.0.1;3306;mangos;mangos;realmd"
</pre>

Change to
<pre>
LoginDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_realm"
</pre>

then for mangosd.conf

<pre>
nano mangosd.conf
</pre>

The lines that need to be changed are:
<pre>
LoginDatabaseInfo = "127.0.0.1;3306;mangos;mangos;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;mangos;mangos;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;mangos;mangos;characters"
ScriptDev2DatabaseInfo = "127.0.0.1;3306;mangos;mangos;mangos"
</pre>

These lines should be changed to:
<pre>
LoginDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_realm"
WorldDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_world"
CharacterDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_characters"
ScriptDev2DatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_scripts"
</pre>

== Map Extraction ==

Go into /opt/mZero/bin and copy these files to your main World of Warcraft directory ( c:\program files\World of Warcraft in Windows. You should know where it is )

<pre>
cp map-extractor [WoW DIR]
cp vmap-extractor [WoW DIR]
cp vmap-assembler [WoW DIR]
cp mmap-generator [WoW DIR]
cp ExtractResources.sh [WoW DIR]
cp MoveMapGen.sh [WoW DIR]
cp offmesh.txt[WoW DIR]
</pre>

== Inserting Database Information ==

<pre>
cd ~/mangos-source/database/Realm/Setup
mysql -u root -p mZero_realm < realmdLoadDB.sql
cd ~/mangos-source/database/Character/Setup
mysql -u root -p mZero_characters < characterLoadDB.sql
cd ~/mangos-source/database/World/Setup
mysql -u root -p mZero_world < mangosdLoadDB.sql
</pre>

=== Inserting Table Information and Full DB ===

<pre>
cd ~/mangos-source/database/
nano make_full_WorldDB.sh

Change the last line to look like this:

for i in /home/mangos/mangos-source/database/World/Setup/FullDB/*.sql; do tail -n +18 $i >> full_db.sql; done

Save the file

bash make_full_WorldDB.sh
mysql -u root -p mZero_world < full_db.sql
</pre>

== Running the Server ==

=== Realmd (Realm Server) ===

go to /opt/mZero/bin and run the realmd server

<pre>
cd /opt/mZero/bin
./realmd
</pre>

If after running realmd and you get an error

<pre>
cd ~/mangos-source/database/Realm/Updates/Rel20
mysql -u root -p mZero_realm < update_the_SQL_file_it_was_screaming_for.sql
</pre>

You should get realmd listening for connections at this time.

=== Mangos (World Server) ===
go to /opt/mZero/bin and run the mangosd server

<pre>
cd /opt/mZero/bin
./mangosd
</pre>

If after running mangosd and you get an error

<pre>
cd ~/mangos-source/database/World/Updates/Rel20
mysql -u root -p mZero_world < update_the_SQL_file_it_was_screaming_for.sql
</pre>

You should get mangosd listening for connections at this time.

== Finalizing running the server ==

I use Screen so you'll have to install this

<pre>
sudo apt-get install screen
</pre>

Then, in the /opt/mZero/bin directory, create a file called runserver.sh

<pre>
#!/bin/sh
cd /opt/mZero/bin
screen -A -m -d -S mangosworld ./mangosd

#!/bin/sh
cd /opt/mZero/bin
screen -A -m -d -S mangosrealm ./realmd
</pre>

Save it and then chmod +x runserver.sh

== Credits ==

If you have any issues with this, please feel free to email me at me@chrisfaulkner.org

Cfaulkner at 08:18, 19 November 2014

2014-11-19T08:18:36Z

@@ Line 64: / Line 64: @@
 sudo apt-get install -y libace-dev libbz2-dev libmysqlclient-dev libncurses5-dev libreadline-dev libssl-dev zlib1g-dev
 </pre>
 == Installing the Database Server (MySQL) ==
@@ Line 228: / Line 232: @@
 <pre>
-cd ~/mangos-source/server/sql/updates
+cd ~/mangos-source/database/Realm/Updates/Rel20
 mysql -u root -p mZero_realm < update_the_SQL_file_it_was_screaming_for.sql
 </pre>
@@ Line 235: / Line 239: @@
 === Mangos (World Server) ===

Cfaulkner at 06:02, 19 November 2014

2014-11-19T06:02:10Z

← Older revision		Revision as of 01:02, 19 November 2014
Line 173:		Line 173:
	The lines that need to be changed are:		The lines that need to be changed are:
	<pre>		<pre>
	~~DataDir = "."~~
	LoginDatabaseInfo = "127.0.0.1;3306;mangos;mangos;realmd"		LoginDatabaseInfo = "127.0.0.1;3306;mangos;mangos;realmd"
	WorldDatabaseInfo = "127.0.0.1;3306;mangos;mangos;mangos"		WorldDatabaseInfo = "127.0.0.1;3306;mangos;mangos;mangos"
Line 182:		Line 181:
	These lines should be changed to:		These lines should be changed to:
	<pre>		<pre>
	~~DataDir = "../data"~~		LoginDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_realm"
	LoginDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_realm"		WorldDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_world"
	WorldDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_world"		CharacterDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_characters"
	CharacterDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_characters"		ScriptDev2DatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_scripts"
	ScriptDev2DatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_scripts"
	</pre>		</pre>

Line 192:		Line 190:

	<pre>		<pre>
	cd ~/mangos-source/~~server~~/~~sql~~		cd ~/mangos-source/database/Realm/Setup
	mysql -u root -p ~~mZero_realmd~~ < ~~realmd~~.sql		mysql -u root -p mZero_realm < realmdLoadDB.sql
	~~mysql~~ -~~u root -p mZero_characters < characters.sql~~		cd ~/mangos-source/database/Character/Setup
	mysql -u root -p ~~mZero_mangos~~ < ~~mangos~~.sql		mysql -u root -p mZero_characters < characterLoadDB.sql
			cd ~/mangos-source/database/World/Setup
	cd ~/mangos-source/~~server~~/~~sql~~/~~scripts/~~		mysql -u root -p mZero_world < mangosdLoadDB.sql

	~~mysql -u root -p scripts < scriptdev2_create_structure_mysql.sql~~
	mysql -u root -p ~~scripts~~ < ~~scriptdev2_script_full~~.sql
	</pre>		</pre>

Line 206:		Line 201:

	<pre>		<pre>
	cd ~/mangos-source/database/~~_tools~~		cd ~/mangos-source/database/
	bash ~~make_full_db~~.sh		nano make_full_WorldDB.sh

			Change the last line to look like this:

			for i in /home/mangos/mangos-source/database/World/Setup/FullDB/*.sql; do tail -n +18 $i >> full_db.sql; done

			Save the file

			bash make_full_WorldDB.sh
	mysql -u root -p mZero_world < full_db.sql		mysql -u root -p mZero_world < full_db.sql
	</pre>		</pre>

Cfaulkner at 05:50, 19 November 2014

2014-11-19T05:50:11Z

← Older revision		Revision as of 00:50, 19 November 2014
Line 173:		Line 173:
	The lines that need to be changed are:		The lines that need to be changed are:
	<pre>		<pre>
			DataDir = "."
	LoginDatabaseInfo = "127.0.0.1;3306;mangos;mangos;realmd"		LoginDatabaseInfo = "127.0.0.1;3306;mangos;mangos;realmd"
	WorldDatabaseInfo = "127.0.0.1;3306;mangos;mangos;mangos"		WorldDatabaseInfo = "127.0.0.1;3306;mangos;mangos;mangos"
Line 181:		Line 182:
	These lines should be changed to:		These lines should be changed to:
	<pre>		<pre>
	LoginDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_realm"		DataDir = "../data"
	WorldDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_world"		LoginDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_realm"
	CharacterDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_characters"		WorldDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_world"
	ScriptDev2DatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_scripts"		CharacterDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_characters"
			ScriptDev2DatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_scripts"
	</pre>		</pre>

Cfaulkner at 05:18, 19 November 2014

2014-11-19T05:18:08Z

← Older revision		Revision as of 00:18, 19 November 2014
Line 22:		Line 22:
	As root, type in:		As root, type in:
	<pre>		<pre>
	apt-get install sudo		apt-get install sudo ssh
	</pre>		</pre>

	After install of sudo, edit the /etc/sudoers file and add ~~your~~ username		After install of sudo, Add the user mangos and edit the /etc/sudoers file and add the mangos username

	<pre>		<pre>
			adduser mangos

	edit /etc/sudoers		edit /etc/sudoers

	Add under 'User Privilege Section' underneath root		Add under 'User Privilege Section' underneath root
	~~username~~ ALL=(ALL:ALL) ALL		mangos ALL=(ALL:ALL) ALL

	Exit and save		Exit and save
	</pre>		</pre>

	Now type in exit and ~~go back to your~~ username. You should have sudo rights now.		Now type in exit and login as mangos username. You should have sudo rights now.

	Type in these commands to establish a build environment		Type in these commands to establish a build environment
Line 114:		Line 116:
	create the directories needed for build		create the directories needed for build
	<pre>		<pre>
	sudo mkdir -p /opt/~~mangos-zero~~/		sudo mkdir -p /opt/mZero/
	sudo mkdir -p /opt/~~mangos-zero~~/logs/mangos-zero/		sudo mkdir -p /opt/mZero/logs/mangos-zero/
	sudo mkdir -p /opt/~~mangos-zero~~/share/mangos-zero/		sudo mkdir -p /opt/mZero/share/mangos-zero/
			sudo chown -R mangos:mangos mZero
	</pre>		</pre>

Line 123:		Line 126:
	mkdir _build		mkdir _build
	cd _build		cd _build
	cmake -DCMAKE_INSTALL_PREFIX=/opt/~~mangos-zero~~ -DCMAKE_BUILD_TYPE=Debug -DWITH_MOD_LUA=0 -DWITH_MOD_SCRIPTDEV2=1 ..		cmake -DCMAKE_INSTALL_PREFIX=/opt/mZero -DCMAKE_BUILD_TYPE=Debug -DWITH_MOD_LUA=0 -DWITH_MOD_SCRIPTDEV2=1 ..
	</pre>		</pre>

Line 129:		Line 132:

	<pre>		<pre>
	~~sudo~~ make		make
	</pre>		</pre>

Line 135:		Line 138:

	<pre>		<pre>
	~~sudo~~ make install		make install
	</pre>		</pre>

Line 141:		Line 144:

	<pre>		<pre>
	cd /opt/~~mangos-zero~~/etc		cd /opt/mZero/etc
	~~sudo~~ cp ahbot.conf.dist ahbot.conf		cp ahbot.conf.dist ahbot.conf
	~~sudo~~ cp mangosd.conf.dist mangosd.conf		cp mangosd.conf.dist mangosd.conf
	~~sudo~~ cp realmd.conf.dist realmd.conf		cp realmd.conf.dist realmd.conf
	</pre>		</pre>

	<pre>		<pre>
	~~sudo~~ nano realmd.conf		nano realmd.conf
	</pre>		</pre>

Line 165:		Line 168:

	<pre>		<pre>
	~~sudo~~ nano mangosd.conf		nano mangosd.conf
	</pre>		</pre>

Line 210:		Line 213:
	=== Realmd (Realm Server) ===		=== Realmd (Realm Server) ===

	go to /opt/~~mangos-zero~~/bin and run the realmd server		go to /opt/mZero/bin and run the realmd server

	<pre>		<pre>
	cd /opt/~~mangos-zero~~/bin		cd /opt/mZero/bin
	~~sudo~~ ./realmd		./realmd
	</pre>		</pre>

	If after running realmd and you get ~~and~~ error		If after running realmd and you get an error

	<pre>		<pre>

Cfaulkner at 05:02, 19 November 2014

2014-11-19T05:02:40Z

← Older revision		Revision as of 00:02, 19 November 2014
Line 178:		Line 178:
	These lines should be changed to:		These lines should be changed to:
	<pre>		<pre>
	LoginDatabaseInfo = "127.0.0.1;3306;mangos;~~mangos~~;mZero_realm"		LoginDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_realm"
	WorldDatabaseInfo = "127.0.0.1;3306;mangos;~~mangos~~;mZero_world"		WorldDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_world"
	CharacterDatabaseInfo = "127.0.0.1;3306;mangos;~~mangos~~;mZero_characters"		CharacterDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_characters"
	ScriptDev2DatabaseInfo = "127.0.0.1;3306;mangos;~~mangos~~;mZero_scripts"		ScriptDev2DatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_scripts"
	</pre>		</pre>

Cfaulkner at 05:00, 19 November 2014

2014-11-19T05:00:53Z

← Older revision		Revision as of 00:00, 19 November 2014
Line 91:		Line 91:
	mysql -u root -p		mysql -u root -p

	CREATE DATABASE `~~mangoZ_characters~~` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;		CREATE DATABASE `mZero_characters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
	CREATE DATABASE `~~mangoZ_realm~~` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;		CREATE DATABASE `mZero_realm` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
	CREATE DATABASE `~~mangoZ_scripts~~` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;		CREATE DATABASE `mZero_scripts` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
	CREATE DATABASE `~~mangoZ_world~~` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;		CREATE DATABASE `mZero_world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
	FLUSH PRIVILEGES ;		FLUSH PRIVILEGES ;
	</pre>		</pre>
Line 123:		Line 123:
	mkdir _build		mkdir _build
	cd _build		cd _build
	cmake -DCMAKE_INSTALL_PREFIX=/opt/mangos-zero -DCMAKE_BUILD_TYPE=Debug -DWITH_MOD_LUA=1 -DWITH_MOD_SCRIPTDEV2=1 ..		cmake -DCMAKE_INSTALL_PREFIX=/opt/mangos-zero -DCMAKE_BUILD_TYPE=Debug -DWITH_MOD_LUA=0 -DWITH_MOD_SCRIPTDEV2=1 ..
	</pre>		</pre>

Line 151:		Line 151:
	</pre>		</pre>

	~~for~~ '''LoginDatabaseInfo'''~~, change the first~~ mangos to ~~your root username for mysql and the second~~ mangos ~~for your~~ password ~~to root.~~		The '''LoginDatabaseInfo''' Variable looks like this
			<pre>
			LoginDatabaseInfo = "127.0.0.1;3306;mangos;mangos;realmd"
			</pre>

			Change to
			<pre>
			LoginDatabaseInfo = "127.0.0.1;3306;mangos;password;mZero_realm"
			</pre>


	then for mangosd.conf		then for mangosd.conf
Line 159:		Line 168:
	</pre>		</pre>

	~~Do essentially the same thing but for~~ LoginDatabaseInfo, WorldDatabaseInfo, CharacterDatabaseInfo ~~and~~ ScriptDev2DatabaseInfo		The lines that need to be changed are:
			<pre>
			LoginDatabaseInfo = "127.0.0.1;3306;mangos;mangos;realmd"
			WorldDatabaseInfo = "127.0.0.1;3306;mangos;mangos;mangos"
			CharacterDatabaseInfo = "127.0.0.1;3306;mangos;mangos;characters"
			ScriptDev2DatabaseInfo = "127.0.0.1;3306;mangos;mangos;mangos"
			</pre>

			These lines should be changed to:
			<pre>
			LoginDatabaseInfo = "127.0.0.1;3306;mangos;mangos;mZero_realm"
			WorldDatabaseInfo = "127.0.0.1;3306;mangos;mangos;mZero_world"
			CharacterDatabaseInfo = "127.0.0.1;3306;mangos;mangos;mZero_characters"
			ScriptDev2DatabaseInfo = "127.0.0.1;3306;mangos;mangos;mZero_scripts"
			</pre>

	== Inserting Database Information ==		== Inserting Database Information ==
Line 165:		Line 188:
	<pre>		<pre>
	cd ~/mangos-source/server/sql		cd ~/mangos-source/server/sql
	mysql -u root -p ~~realmd~~ < realmd.sql		mysql -u root -p mZero_realmd < realmd.sql
	mysql -u root -p ~~characters~~ < characters.sql		mysql -u root -p mZero_characters < characters.sql
	mysql -u root -p ~~mangos~~ < mangos.sql		mysql -u root -p mZero_mangos < mangos.sql

	cd ~/mangos-source/server/sql/scripts/		cd ~/mangos-source/server/sql/scripts/

	mysql -u root -p ~~< scriptdev2_create_database.sql~~		mysql -u root -p scripts < scriptdev2_create_structure_mysql.sql
	~~mysql -u root -p scriptdev2~~ < scriptdev2_create_structure_mysql.sql		mysql -u root -p scripts < scriptdev2_script_full.sql
	mysql -u root -p ~~scriptdev2~~ < scriptdev2_script_full.sql
	</pre>		</pre>

Line 181:		Line 203:
	cd ~/mangos-source/database/_tools		cd ~/mangos-source/database/_tools
	bash make_full_db.sh		bash make_full_db.sh
	mysql -u root -p ~~mangos~~ < full_db.sql		mysql -u root -p mZero_world < full_db.sql
	</pre>		</pre>

Line 199:		Line 221:
	<pre>		<pre>
	cd ~/mangos-source/server/sql/updates		cd ~/mangos-source/server/sql/updates
	mysql -u root -p ~~realmd~~ < update_the_SQL_file_it_was_screaming_for.sql		mysql -u root -p mZero_realm < update_the_SQL_file_it_was_screaming_for.sql
	</pre>		</pre>

Cfaulkner at 04:47, 19 November 2014

2014-11-19T04:47:34Z

← Older revision		Revision as of 23:47, 18 November 2014
Line 105:		Line 105:
	mkdir mangos-source		mkdir mangos-source
	cd mangos-source		cd mangos-source
	git clone --recursive https://github.com/mangoszero/server		git clone --recursive -b Rel20 https://github.com/mangoszero/server
	git clone --recursive https://github.com/mangoszero/database		git clone --recursive -b Rel20 https://github.com/mangoszero/database
	</pre>		</pre>