-
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
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
very good guide congratz ! , can complete and translate to espanish please ??
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
Where to get Mysql 2005 full?
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
nice guide only one correction: its not my sql but mssql
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
ok man kool, ill grab ya link for the SQL 2005 full :P
Visual Studio 2005: Download
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
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.
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
FOUND A FIX!
it is becuase i m not allwed to rename the MuOnline to MuServer
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
What's the point of using MySQL if you can easily use MSSQL ?
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
Anyone help? Look at this error..
Thanks, Michael!
*******************************
http://img164.imageshack.us/img164/5863/heeelpjy4.jpg
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
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
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
i got this error when i try to restore the MuOnline database.
http://img470.imageshack.us/img470/1...rrordv7.th.png
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
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...
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
This is MSSQL 2005 There is NO MYSQL 2005!
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
nice guide,im also converting mysql guide of mu to mysql 2005 because mysql 2005 is the latest and much easier to use
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
how to create 100% server on sql 2005 windows vista?
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
2007 thread dude -.-
ask on helpsection..
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
Please Releases This Topic ;(
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
Can u update the pictures? plz
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
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
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
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
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
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
-
1 Attachment(s)
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
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
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
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.
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
you got teamviewer there? btw are you using 64bit OS?
-
Re: [Guide] Setting up MY SQL 2005. for a Mu Server (not 100% done)
dude i dont see any picture in ur turotial