[Solved]Mangos Zero Rel20: Problems with downloading and importing the database Data

[Goullio]

Hello all,

at the moment i'm trying to set up a mangos zero server. I downloaded the "Mangosero_Rel20_BETA_X32_NOV2014.zip" (downloaded 23 Nov) file and also i used the wiki guide "How to setup a MaNGOS Zero Server from Scratch, (note: only for mangoszero REL20)"

I have tried several times to set up a Mangos Zero server with the guide, however every time i failed to get it running properly. There are a few steps that i simply don't really understand, i do not really have a IT-background so mostly i'm experimenting to try to get it running. The steps i'm not able to complete are: ''Downloading and Importing the Database Data', step 1 after git bashing the database.git:

1. cd server/sql

2. Installer_DB.cmd

i have two questions about this step:

1. First, if i understood correctly, i have to do this in GIT, typing these lines, however when i do, i get the error: sh.exe: Installer_DB.cmd: Command not found

2. The Installer_DB.cmd (file?) isn't in my server sql map, so i'm at a loss here about what to do next.

I tried ignoring this step, but it seems that i can't run my server (realmd functions properly, but the mangosd.exe closes Instantaneously.

Note: i used the git bash line for the server files as following: git clone --recursive https://github.com/mangoszero/server.git

Could someone please explain to me what i have to do to get it working.

thanks for your time,

Goullio

[madmax]

Hey,

If you have downloaded the precompiled mangos zero server you don't need to be downloading source as all the files are included in the zip.

You need to make sure you got your mysql server up and running. You can then use a tool such as sqlyog community edition and connect to that and setup the databases with that and then import the .sql files under the database folder into there databases.

Should be a matter of creating characters, mangos and realmd databases and then importing the sql's, so for the characters database you would go into the characters folder and import characterLoadDB.sql

For the mangos database you just need to import mangos_full_db.sql as this has everything already done for you. - There may be some updates to run from the updates folder but when you load the server it will tell you if the database is outdated.

realmd database is simply importing realmdLoadDB.sql

You also need to make sure you copy the files in the clientmapextractors folder into the root of the wow folder and browse there in command line and run ExtractResources.sh via command line and follow the instrctions, once this is done you need to copy dbc, maps, vmaps, mmaps into whichever folder you are running the mangosd.exe from.

If you'd like help with this drop me a PM via the site with skype details and make sure you have teamviewer setup and I can come on and show you how to set this up if you get really stuck.

[Goullio]

Thank you for your help. I imported the SQL files succesfully however i failed to update the database. When i try to start the server i get this next:

it is as you said: updating the Mangos database. I tried to get update file [A] - in the correct order however then i get the following error message:

Query:

ALTER TABLE db_version CHANGE COLUMN required_20002_creature_template_power required_20003_01_mangos_spell_bonus_data bit

Error occured at:2014-11-28 19:00:44

Line no.:1

Error Code: 1054 - Unknown column 'required_20002_creature_template_power' in 'db_version'

These error's continue when i try to update the preceding files requested. Where did i go wrong? is my database connected correctly or do i have to update another way?

as well: The MangosD.exe closes instantly when trying to activate it, my realmd.exe is functioning properly.

[antz]

Looking at the error message, it looks like you are missing some updates

if you have the database stored locally, go into the World/Updates/Rel20 folder and apply the update

20003_04_mangos_spell_bonus_data.sql and all updates after it upto and including 20003_17_Molten_Core_Portal_Fix.sql

If not the repo is located at:

[url]https://github.com/mangoszero/database/tree/Rel20/World/Updates/Rel20[/url]

[Goullio]

Could you please tell me how i can apply these updates to my database?ly these updates to my database?

Update: It seems i got it all working, thanks alot!

[valen]

I got everything downloaded and running but the Rexxar patches would not load so I skipped them for now. It was having a primary key issue.

On an off note, Max and Antz thank you guys for the work put into this. Vanilla was always my favorite and this brings back the memories.

Thanks

[valen]

If you downloaded MySQL community, you can install the patches manually by opening the database (clicking it twice) and then clicking File from the toolbar, then Run SQL Script. This will open a windows explorer window (if you are running windows), then navigate to the location you saved the updates (patches) locally. Select the file and hit open. This will display the first 1024 characters of the patch, basically enough to make sure you got the right one. Select the Default Scheme Name, which is almost all Mangos. Then hit run. This will import the script if there is an error it will let you know. The only two updates I could not get to install were the two Rexxar pathing patches. Once you get down to the Molten Core portal patch you can flip over to the directory and boot it up. it should run if you got the Precompiled files Madmax uploaded about 3 weeks ago. You will see a bunch of red pop up (at least I did) in the boot up sequence, do not be alarmed it will still boot. once it gets to the portion where it says it took XXX seconds to boot you should be ready to create your user account unless you plan to just use the GM account. I haven't patched past the Molten Core Portal yet but I will probably do so this weekend, I am hoping it wont require me to re-compile the Mangos files.

I hope this helps.

[madmax]

Going to close this topic off now as the starter has resolved there issue.