scarfaze1

You need blank sql files, then UDB CleanInstall, then UDB updates 380 and 381 files, then udb update file, then mangos\\sql\\updates. Pay attention to table db_version, last column says required_xxxx_xx_mangos/characters/realmd for each database. Each update sql file, 380, 381 and mangos\\sql\\update will change that column. You will see in sql files ALTER TABLE db_version CHANGE COLUMN required_xxx_xx_mangos...

realmd database has table realmd_db_version you apply xxxx_xx_realmd to that db

mangos db has table db_version you apply xxxx_xx_mangos... to that

characters has table characters_db_version and you apply xxxx_xx_characters updates to that

but keep an eye on that last column in that table and compare that number with the number on the name of sql update file. any sql update file that has number greater than the number in the column you need to apply in sequential order. Though, this is partially UDB related, so you should check out their forums. Look at the Resources thread which is linked in my signature.

127.0.0.1 does nothing but loopback. No other computer will ever be able to connect to server if your using 127.0.0.1. Only time for 127.0.0.1 is in conf files. In database look at realmd in table realmlist. It will show mangos realm as id 1, you will see column name address. enter lan ip address there. also, for more info there is a sticky on this forum nameed hosting behind router. read up in there.

Thanks to you, and I would send you cookies if that was possible, solved all of my problems

Mangos.sql is a blank database. If you want content, you need to download a content database, such as UDB.

That was just what I was talking about, but I am wondering in what order I would have to execute? In the guide it says that I have to do the blank ones from my SQL folder first, then download and update? But I am having problems with that

I have tried first executing the blank ones, then the 11.5 core from UDB, then all the updates from 11.5, but when I update I get errors. So as I said, my question is in what order should I execute sql's into the database?

Setting up the databases

-Run SQLyog

-Click the "New Connection" button at the top of the connection window somewhere

-Name the connection anything you like

-Fill out the fields as indicated below:

MySQL Host Address: This is "127.0.0.1" or "localhost" for playing singleplayer or LAN; if you want to put your server online, put this as the IP or DNS of the server that MaNGOS is being hosted on.

Username: Type in "root".

Password: This is the password you set up when you installed the MySQL Community Server.

Database(s): Leave this blank for now.

-Click "Connect"

Adding Databases

-In the top left-hand side, right-click "root@(IP here)"

-Click "Create Database"

-For the database name type in "realmd"

-Do the same, except for two more databases named "mangos" and "characters"

Once that's done...

-Click "File" in the menu at the top of SQLyog

-Click "New Connection"

-This time in the databases field, type:

realmd;mangos;characters

-When SQLyog asks if you'd like to save the changes, choose yes

-Click "Connect"

-Now, in the left-hand database list, right-click "realmd" and click "Restore from SQL Dump"

-Click "Browse", and select your MaNGOS source folder, then go into the "sql" folder and select realmd.sql

-Click "Execute"

Once that's done...

-Right-click "characters" and select "Restore from SQL Dump"

-Click "Browse", and select the characters.sql in the same sql folder

-Click "Execute"

Once that's done...

-Go here to download the newest UDB database (contains all the world stuff)

-Make sure that your MaNGOS core is up-to-date with the database (check your core's revision number, then the compatible revision number within the file title of the UDB database)

-Download the latest UDB update packs here (if that link doesn't work, go here and find the updates folder in /trunk)

I am having problems here, when fixing the databases

I made mangos, realmd and characters

Then I executed mangos.sql, realmd.sql and characters.sql into the databases from my /sql folder

But now my problem is that when I log in evreything is gone, of course I understand that I have to download the 11.5 core and execute it into the database, but now I am getting compatibility issues? Can someone please help me? Maybe the updates for 11.5 or the CLEANINSTALL_ONLY folders should help?

Sorry I am noob at this, but I really want to get on with the C++