Petzy

as far as i can tell, you open that with notepad (wordpad works better at buffering that huge text) you wait patiently for it to load, ctrl + a and ctrl + c everything inside, then with sqlyog you go select mangos database, and in Query paste that, wait patient, that ctrl + a what you just pasted in the Query, and click the second icon starting from the left up in the menu of sqlyog (execute / play) then wait for it to finish im not 100% sure but this seems to be the answer as best as i can tell so far, im waiting for answers too

Thanks for the kind explanation mate, i followed your advice and went to udb forums, diden't get a thing there either, it's just too beyond me this database thing Maybe you could point me to a link with detailed explanation on what it is, how to and so on ? would really appreciate it.

Hello, i am new to the forum but i joined especially for this guide. Which is great by the way, the only problem i have is the way you explain; Im guessing your English is native, my own isn't that's why i am having a hard time understanding some of the things you wrote, and so i can't move forward and complete the server, my problems are as follows: Problem 1. The download link for MySQL server your provided leads to a page that has been removed, mysql 6.0 was the version, so..i got instead this: mysql-5.4.2-beta-win32 , hope it's ok. I installed it and works well..fine i guess. The problem is MySQL.exe isn't showing up in my task manager and dosen't seem to be running I am using vista. I configured the mysql, done everything like you said and everything went well without any errors or so on, but i was wondering that because it isn't appearing in Task Manager as a running process, it diden't work, am i mistaken? Problem 2. I am using Dynamic IP Adress that's the way my ISP is, i connect threw PPPoE using user&pass, so everytime i connect, i get a different IP, so to that end i have Download and Created and account at DynDNS.com. There i've chose a hostname, namely petzy.ath.cx I downloaded they're little updating program and it stays always on and connect in my Tray, basically it syncronizes my IP adress (which ever it is, even if it changes) with the petzy.ath.cx hostname, so if someone were to connect to my computer by what ever means, it would be enough for them to just type in the connection box petzy.ath.cx instead of my IP. Ok, my problem now is this; when i open SQLyog and type in the MySQL Host Adress field the hostname localhost it connects succesfully, but when i type petzy.ath.cx i get the following error: Why? I want the server to be online, so that anyone can join and play on it, the server will run on my PC that's why i use the DNS Updater so that if i change ip's they can still connect to the server using only that hostname. So as best i understand so far, i have to also connect to petzy.ath.cx in SQLyog or i can just use localhost ? If i use localhost in SQLyog, wouldn't that mean others won't be able to connect to the server and play? this part i don't understand, if you can please help me with an answer. The reason i don't understand this is because you said i should put the ip or dns in that field of the PC where the server will be hosted on, so i did, and it won't connect, it will only connect if i type localhost in. Problem 3. So, in my effort to understand further, i used localhost and continued on with the Guide, skipped that part i quoted above. I did this succesfully: So i did all this without a glitch so far, but i got stuck again at this: I did this, and downloaded this: UDB_0.11.5_Core_7681_SD2_1012.rar Problem is, i don't understand what to do with this. Further problem: I got no idea how to do this. Diden't understand this at all, i still have to do it? or i got it right the first time when i downloaded that .rar ? Problem 4. I don't understand this at all. Which .sql file to open with notepad? from where? you lost me here ----- Ok, those are my problems, now comes this: Configuring MaNGOS and so on in the guide, till it finishes. I know how to do all that, and already done it, no problems there. So my main problems are the ones stated above. One additional question besides those problems: In realmd.conf should i leave this 0.0.0.0 or petzy.ath.cx ? it was set by default to 0.0.0.0 and i changed it to petzy.ath.cx BindIP = "petzy.ath.cx" And shouldn't i "Restore From SQL Dump" mangos.sql too? you mentioned only realmd.sql and characthers.sql in the Restore from sql dump part of the guide, what about mangosd.sql? i see there is that file too there in the folder, just wondering why u diden't mention it too forgot? or dosen't have to be restored from sql dump like the realmd and characters? Sorry for my long post, i just tryed to explain as best i could my problems Im not that good at English so i hope you understand. Really looking forward for some "n00b friendly" answers, thanks allot!