Thanks for your reply.
I am actually using PHP and I tried what you suggested.
$link1 = mysql_connect("server1.com", "www", "pass") or die("could ...");
$link2 = mysql_connect("server1.com", "www", "pass") or die("could ...");
there is no error but it is not working.
Please not that I am using the same server.
Fred Kamwaza.
------------
> I donīt know what API or languaje are you usin, but i think in c, perl,
> php you should open two conection with two diferent names
>
> $link=mysql_connect("192.168.1.11", "www", "pass") or die ("Could not
> connect");
> $link2=mysql_connect("192.168.1.10", "www", "pass") or die ("Could not
> connect");
>
>
> and work with the pointers all time
>
> I think it should work
>
>
>> -----Mensaje original-----
>> De: Fred Kamwaza [mailto:[EMAIL PROTECTED]]
>> Enviado el: lunes, 10 de junio de 2002 13:22
>> Para: [EMAIL PROTECTED]
>> Asunto: How do I connect to two databases at the same time
>>
>>
>> Can you help!!
>>
>> I have two databases on one MySql sever and I would like to transfer
>> certain information from one databases to another. I want to
>> transfer, record by record, from a particular table, after examining
>> the
>> record. How
>> can I open the two databases at the same time?
>> The only way I am able to do this is by
>>
>> 1. opening one database -
>> 2. read a record from a particular table -
>> 3. close the database -
>> 4. examine the records -
>> 5. open the other database -
>> 6. save information and close.
>>
>> 7. repeat the process for all the records.
>>
>> I am worried that this may be in efficient. It there another I
>> could do it?
>>
>>
>> Fred Kamwaza
>>
>>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
