Setting up MY SQL 2005. for a Mu Server (not 100% done)

im going to say sorry ahead of time if this guide is no help, as i am a noob learning, i just want to share the information i know i will also do the best i can by displaying pictures for the steps.

This is kinda with using MySQL 2005 but here i go(sry if rong place just trying to help

1st: Download the MySQL server
Then go to Start--> all Programs--> my SQL server 2005-->SQL Server Management Studios Express.
this will bring you to the first Area of MYSQL, just Click Connect to start.
after you Click connect you should see this screen:

http://i149.photobucket.com/albums/s...e/SQLstart.jpg



Then Click on the SQL Express and get to the Database area. right click on Database and click new Database.(picture shown Below):
http://i149.photobucket.com/albums/s...ewdatabase.jpg

Then you Type in Muonline and Press OK (Picture Below):
http://i149.photobucket.com/albums/s...wdatabase2.jpg

Next you go to That database you made. right click on it. and then click on tasks then Restore database. after that you need to choose From Device and browse through you Server Files to find the folder Database, or Db bak. then you find the file Muonline.bak (Note: to use this you must pick. File type: All files). and here is a picture to show kinda a bit of that step:
http://i149.photobucket.com/albums/s...ence/mubak.jpg

now once you select muonline.bak you need to click ok... then ok again. u will go back to the last screen, select the Muonline Database then go to Options and Click overwrite the Existing Database. and your finished that part. Congradulations. here is another pic:

http://i149.photobucket.com/albums/s.../overwrite.jpg

now. you do the Exact same thing 2 more times but! instead of using the Muonline. use the Rankings.bak And the ExDb.bak (also a note: all Server files are different and you may not have ExDb just Repeat this step with all the files you have in your Database folder) and once your finished your SQL Server Setup should look somthing like this:

After this. to complete the Mu Server you must Make ODBC(data source Links) to connect to My SQL. and then Forwardthe ports:

http://i149.photobucket.com/albums/s...nce/finish.jpg
44405 BOTH [TCP/UDP]
55557 BOTH
55901 BOTH
50001 BOTH
50019 BOTH
50000 BOTH
(im not sure if these are the Exact ports~i just got them from another Guide)
then Edit Your MuServer Files and Replace the Ip's in them with your own. and (dont forget the Links~u must go to properties to edit those. The Links you will need to change the ip's of is:
Chat Server
Data Server 1&2&3(on most)
ExDb
GameServer
Join Server
And Siege Server.


Then of corse you Edit all of the Rest of your Files with your ip. and then try out the links :P


hope this guide helps a bit.

Remenence~Newb And Still Learning

any like??

very good guide congratz ! , can complete and translate to espanish please ??

Where to get Mysql 2005 full?

nice guide only one correction: its not my sql but mssql

ok man kool, ill grab ya link for the SQL 2005 full :P

Visual Studio 2005: Download

Quote:

---

Originally Posted by capaso

very good guide congratz ! , can complete and translate to spanish please ??

---

and maybe u can try:
Free Translation and Professional Translation Services from SDL International

to get your translation into Spanish. it is a good translation system if you need. its just i dont speak spanish soo... just Copy and paste the Text of what you want translated.

Cool guide... :)

http://img113.imageshack.us/img113/8088/untitledon3.jpg

wtf? why i cant restore the db? -.-

FOUND A FIX!

it is becuase i m not allwed to rename the MuOnline to MuServer

nvm it fixed

What's the point of using MySQL if you can easily use MSSQL ?

Anyone help? Look at this error..

Thanks, Michael!
*******************************

http://img164.imageshack.us/img164/5863/heeelpjy4.jpg

Quote:

---

Originally Posted by Intelext

What's the point of using MySQL if you can easily use MSSQL ?

---

its not actually my sql he jus named it wrong so the guide is for mssql2005

i got this error when i try to restore the MuOnline database.
http://img470.imageshack.us/img470/1...rrordv7.th.png

Lols. This is a guide. Not a help thread.

If you got problems. Go to Mu Server and Client Help And post it there...


Nice guide dude...

This is MSSQL 2005 There is NO MYSQL 2005!

nice guide,im also converting mysql guide of mu to mysql 2005 because mysql 2005 is the latest and much easier to use

how to create 100% server on sql 2005 windows vista?

2007 thread dude -.-
ask on helpsection..

Please Releases This Topic ;(

Can u update the pictures? plz

i have a problem
at your very first point.
''this will bring you to the first Area of MYSQL, just Click Connect to start.
after you Click connect you should see this screen:''

i end up with this error
http://img693.imageshack.us/img693/1553/beztytuubi.png
can some1 help

Quote:

---

Originally Posted by ozone9994

i have a problem
at your very first point.
''this will bring you to the first Area of MYSQL, just Click Connect to start.
after you Click connect you should see this screen:''

i end up with this error
http://img693.imageshack.us/img693/1553/beztytuubi.png
can some1 help

---

servername should be the name of your pc not MUONLINE

Quote:

---

Originally Posted by evo1123

servername should be the name of your pc not MUONLINE

---

Ok
i have changed that to my computer name but the error keeps on accuring
http://img94.imageshack.us/img94/3134/aaaaaq.png


And there isn't any servers when i sellect the option ''Browse for me''
has any1 got a clue?
im using windows 7 ultimate if this helps

for servername it should be your PCname

for authentication it should be sql server authentication

login is sa (default)

password is the password you put when you install it

Attachment 73788

Quote:

---

Originally Posted by evo1123

for servername it should be your PCname

for authentication it should be sql server authentication

login is sa (default)

password is the password you put when you install it

Attachment 73788

---

Error 20 still accurs even if everything you said is correct.

you got teamviewer there? btw are you using 64bit OS?

dude i dont see any picture in ur turotial