connecting mysql to another Database

03/11/2011 00:31 korn87_87#1
me and my friend are wanting to make our on dekaron private server and was wondering how would we connect out mysql databases together so both of us can work on the server files instead of just one of us

Thanks ^^
03/11/2011 01:31 Zektor#2
This game doesn't use MySQL, unless you're using a custom emulation for dekaron servers that uses MySQL.
03/11/2011 01:38 korn87_87#3
my friend is using VMware as an emulator for the server and i want to use mysql to connect to his database to help with editing files and such
03/11/2011 01:38 thuggin#4
dude he is talkin bout he wants to join someone elses ps as a DEV and needs to know how he can do stuff to the server like the main host can
03/11/2011 01:47 Zektor#5
He's clearly still talking about Dekaron, which doesn't involve MySQL at all. (It uses MSSQL)
03/11/2011 02:00 korn87_87#6
o lol i do use mssql my bad bad typing i guess on my part.
so can i join his database or not?
03/11/2011 04:41 Zektor#7
You can connect to his database, as long as his port 1433 is opened, and then you can access it directly by connecting to his IP as hostname, and putting in the SQL auth.

Also you'd have to make sure you have privileges to connect, normally by default it will allow you to connect straight away, if not you'd need to activate it... Can't seem to remember where...
03/11/2011 05:34 thuggin#8
ok im sorry you are right i just glanced at his mssql and did not see he had written mysql(stupid on his part^^)thats my fault.
03/11/2011 12:34 ҉ THT ҉#9
the biggest problem why we cant use MySQL is that MySQL doesn't support and communication with .EXE and SP.
03/12/2011 08:40 -8gX#10
ACTUALLY THT, it is possible.... Using ODBC connections in the control panel, it should be very possible to 'trick' dkserver.exe to thinking its connecting to a MSSQL database, while in reality it is connecting to a MySQL. Also, check out this link: [Only registered and activated users can see links. Click Here To Register...]

Mysql DOES support stored procedures, just no one has taken the time to rewrite all the ones in the dekaron databases into mysql code.

NOW! Back to the original question, you can either host the server on a dedicated server, and give login information to both of you. Or, have him run his computer 24/7 with port 1433 open and create a remote account on YOUR machine in Query Manager, with HIS IP address and database name in the form of "123.123.123.123\\MSSQL-SERVER" with the proper login credentials. Then you will be able to run remote queries and stuff from your machine.

Give this a look as well, the first post explains it pretty nicely: [Only registered and activated users can see links. Click Here To Register...]
Any other questions?
03/13/2011 04:02 korn87_87#11
well ty for the reply m8, as for other questions kinda i was wondering how you make it to were you can wear multiple rings like Caligos, Zevech, and Dark eye at the same time??
03/13/2011 07:59 -8gX#12
Try itemetc.csv I believe, there should be a column, someone please correct me if I am wrong.