Great thx
Getting the networking stuff done will probabely not be that much of a problem.
I'm more worried about the ways PostgreSQL and MySQL differ in opening
sockets, handling data and differences in used functions.
Well, i did a quick dump of the HM-DB structure, converted it to MySql and
imported. Everything went in fine untill
Code:
CREATE TABLE postflopactions(
compiledplayerresults_id int( 11 ) NOT NULL ,
streetactiontype_id smallint NOT NULL ,
count smallint NOT NULL ,
betorraise smallint NOT NULL ,
checks smallint NOT NULL ,
checkcall smallint NOT NULL ,
checkfold smallint NOT NULL ,
checkraise smallint NOT NULL ,
bet smallint NOT NULL ,
betcall smallint NOT NULL ,
betraise smallint NOT NULL ,
betfold smallint NOT NULL ,
raise smallint NOT NULL ,
raisecall smallint NOT NULL ,
raiseraise smallint NOT NULL ,
raisefold smallint NOT NULL ,
call smallint NOT NULL ,
callcall smallint NOT NULL ,
callraise smallint NOT NULL ,
callfold smallint NOT NULL ,
fold smallint NOT NULL ,
unopenedinposition smallint NOT NULL ,
betunopenedinposition smallint NOT NULL ,
totalbets smallint NOT NULL ,
totalcalls smallint NOT NULL ,
sawshowdown smallint NOT NULL ,
wonshowdown smallint NOT NULL
) TYPE = MYISAM
which throws this err
Code:
#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 'call smallint NOT NULL,
callcall smallint NOT NULL,
callraise smallint' at line 18
Now i'm wondering if call might be a reserved entity in MySQL but not in PostgreSQL.
Since i never even really touched Postgre before, except for the use with
HM, all i can make is an uneducated guess, So if anyone wants to join in, help
is greatly appreciated.
Update
I changed all the single "call" to "calll" and the SQL imported fine.
Update
I renamed the altered tablenames back to call.
Now i'm trying to establish connection via HM Database Control Panel,
where i need to specify the DB-Name manually because it is fixed by my hoster.
Since there is no way to do that via the HMDBCP is there a config file (or anything manually editable) in HM
where i can alter the default DB-Name?
Update
Found and manually edited the config file.
HM opened an outgoing connection to the given server -> good.
But failed to connect -> bad.
Working on it.