[Guide] How to set up a 3.0.3 private server! ( Really easy, with pictures! )

[sirinith]

the problem im having is that the realm will not load. any clues as to why?

[SteelWolf]

I noticed that some things were skipped in the "step by step" initial setup instruction. Like "Execute your world file" You forgot to say that you had to load it from a specific file. Late on you just say change all the yellow text. That section could use a little more work. Like you did with the red arrow. Draw one to a side note that descripes what IP address to use. Passwords? Do they need to match the SQL pr just each other. Some of the problems people had could have been avoided if the details were there a little more. I used a similar guide just after TBC came out. Step by step it worked fine. The only bug i did have was skimming the guide and missing a realmchange and eventually plugged in my hamachi IP. I like the guide. I'll give it a 3.5 out of 5 for presuming people had done it before.

[Stealthyguy^^]

Uhm, nvm my other reply... my fault.. didnt check all the commands, noticed it were .character additem and such. but i still don't know why i can't make a DK without getting Disconnected..

[Romis]

I noticed that some things were skipped in the "step by step" initial setup instruction. Like "Execute your world file" You forgot to say that you had to load it from a specific file. Late on you just say change all the yellow text. That section could use a little more work. Like you did with the red arrow. Draw one to a side note that descripes what IP address to use. Passwords? Do they need to match the SQL pr just each other. Some of the problems people had could have been avoided if the details were there a little more. I used a similar guide just after TBC came out. Step by step it worked fine. The only bug i did have was skimming the guide and missing a realmchange and eventually plugged in my hamachi IP. I like the guide. I'll give it a 3.5 out of 5 for presuming people had done it before.

Thank you! I will try to change it accordingly.

Edit:

Changed, thank you once more for the helpful comment.

[Rare23]

i got DC if i try to create new character.

why ?

[shadowx850]

hi every time i execute the batch file for the database world i got this error [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@'@'ä
' at line 1
[Err] INSERT INTO `trainer_spells` VALUES @'@'ä

[Msg] Finished - Unsuccessfully i don't know why because i do the same thing for the logon and i got no error can you help me whit that plz

[sirinith]

ok i fixed my logon problem but now i enter the world and there is nothing their and 3 seconds later i get D/C can someone PLEASE HELP WITH THIS PROBLEM! its very annoying

[Dragonhughes]

When you execute the files, what do you put in the "File" field before you press "Start" please?

[lancingluke]

Thanks !!

[Drekko]

You may wanna add which files to execute during the "execute batch file" part. Not everyone knows

[ronald911]

Can someone do me a favor, cause rapidshare dont work in africa. Can you please upload it to another site please? like Filebeam - Free Fast File Hosting.
Thanks

[Dragonhughes]

Thanks Drekko got that now, but now when I execute, I get the errors :
[Err] Access violation at address 01CB954C in module 'libmysql_c.dll'. Read of address 0182C000
[Err] MZ
[Msg] Finished - Unsuccessfully
--------------------------------------------------
and
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MZ' at line 1
[Err] MZ
[Msg] Finished - Unsuccessfully
--------------------------------------------------
I realised other people had problems like this also, just stuck at this stage.

[Pierrick584]

tried to download the first link to folow the tutorial, computer crashed and rebooted with a virus, thanks alot

[frozenbyte]

When I try to finish MySQL Installer it says Access denied for user 'root'@'localhost'(using password: YES)

[karmapolice]

hi every time i execute the batch file for the database world i got this error [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@'@'ä
' at line 1
[Err] INSERT INTO `trainer_spells` VALUES @'@'ä

[Msg] Finished - Unsuccessfully i don't know why because i do the same thing for the logon and i got no error can you help me whit that plz

The file looks corrupted. Who didn't stuck, is because used the option "continue on errors". The corruption sounds like is just in one line, exactly when begins the trainer_spells.

What I did is continue like this, then after I did restore from sql dump (SQLYog) > the database.sql downloaded from ncdp.