Multiple MySQL connects?

[nemonoman]

Hi:

Instead of spending the next 3 days investigating, I thought I'd ask for some help for a change.

I'm trying to figure out how to do multiple MySQL connects. I keep having trouble, but probably somebody knows how to do this.

I want to take data from my MySQL db on my own hard drive (localhost), and transfer it to one or more databases on my internet servers.

(I can't just do a dump and upload because auto_sequencing of foreign keyed records gets me in trouble. For example, person (record 10) on my development db creates one or more records (say records 101 and 102) and one or more address records (say 202, 203, and 204). On the working internet dbs, the record numbers for those foreign records may already be used and totally different when I upload them. I need to be able to figure out the foreign keys for all these records as I upload all the data).

What it boils down to is: it's FAIRLY easy if I can just get multiple connections going at once. Don't know if this can be done, however.

Can I do something like:

function connect1(){
$connect1=mysql_connect('localhost', 'localuser', 'localpass');
$db1=mysql_select_db('localdb');
}

function connect2(){
$connect2=mysql_connect('server.com', 'serveruser, 'serverpass');
$db2=mysql_select_db('serverdb');
}

function connect3(){
$connect3=mysql_connect('server.com', 'serveruser, 'serverpass');
$db3=mysql_select_db('Yetanotherdb');
}

then do something like:

connect1();
$result1=mysql_query("SELECT 'some local info' from sometable");
$row=mysql_fetch_array($result1);
$somedata=$row[0];

connect2();
$result=mysql_query("UPDATE sometable SET somecolumn='$somedata'");

and thereby transfer data from db1 to db2?

The connect string I use on my internet servers includes "localhost" as one of the parameters. Hadn't investigated this until now, as this works fine as currently operating, but my guess is I need to use either a .com type name or a IP address. Any pointers?

All info welcome.

Thanks.

Nemo

[cgraz]

I think you can do

$c1 = mysql_connect($server1, $username1, $password1) or die(mysql_error());
mysql_select_db($database, $c1); // note the $c1. 

$c2 = mysql_connect($server2, $username2, $password2) or die(mysql_error());
mysql_select_db($database, $c2); // note the $c2. 

$c3 = mysql_connect($server3, $username3, $password3) or die(mysql_error());
mysql_select_db($database, $c3); // note the $c3. 

Then when you run your query's, you can do

$query = mysql_query("SELECT * FROM table", $c2) or die(mysql_error());

Now i've never actually done this, this is only a guess as to how to do it, but what else would you be able to specify the connection link for if you couldn't use it this way?

Cgraz

[nemonoman]

thanks cgraz:

I just reread TFM. Looks like your approach is what I was seeking.

I saw but originally didn't grok the extra parameter, probably because of the manual format I was reading. The online manual @ php.net, with its ensuing user comments, helped to emphasize the lesson you taught me in your answer.

I owe you one.

PS. I suppose I need to supply a host reference for my internet server, as 'localhost' appears to refer to my PC's hard drive.

What is the format likely to be?
www.somename.com

OR

somename.com

OR

123.45.67.89

This could be dangerous, as I think my ISP uses some tricky IP addressing.

?

[cgraz]

You'd need to contact your host for that one. It really depends on their setup. My host allows me to use localhost for the server parameter.

Cgraz