how bad is this?!

toshog

ok here is a question:

a php script that runs every 5 min. the script is a loop that connects to the local host mysql and a remote host mysql for each loop step.
the first part of the step of each loop gets information that the second one needs. but since the second part connection overwrites the connection of the first part i have to connect again to the first host in the beginning of a new loop...

how bad is that? can i have two connections open simultaniously?

thanks....

planetsim

Im pretty sure you can only have one... But im pretty sure what you are doing is possible just close the connection once its finished and open a new one..

toshog

i am doing it - i was just asking in therms of "how correct is that way"?.

thanks..

drawmack

it appears you're doing some kind of backup. I usually do this one of two ways.

small database solution
create a multidimension array and store the table's info into it like so:

<?
//connect to db 1
$sql = "SELECT * FROM table";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result) {
   array_push($table,$row);
} //end while
//disconnect from db1
//connect to db2
//loop to insert data from $table into the database
?>

large database solution:
use two scripts
script1 - dumps the data into csv files
script2 - pulls the text files into the other database
then run these with a time off set large enough that they don't conflict in running.

ramkumar_unknow

Try using mysql_pconnect, in this way u will using only 2 connections totally.