how can we retrive value from one database server and store them another datab

how can we retrive value from one database server and store
them another database server using php?

Question Posted / subrata

3 Answers
7235 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how can we retrive value from one database server and store them another database server using php..

Answer / sunilchai

just connect to the datbase server from php using the
mysql_connect and store the connection identifier in a
variable and then fetch the data from the server and the
close the server connections using mysql_close() and then
connect to another server and insert the value there

/// sample scriopt

$db=mysql_pconnect("host","username","pssword");
mysql_select_db("dtabase name",$db);
$query="select * from the table";
$res=mysql_fetch_object(mysql_query($query));
mysql_close($db);

///connected to the first server fetch the data and stored
in the $res varialble

$db=mysql_pconnect("secondhost","username","pssword");
mysql_select_db("dtabase name",$db);
$query="insert into tablename values($res)";
mysql_close($db);

Is This Answer Correct ?

9 Yes

2 No

how can we retrive value from one database server and store them another database server using php..

Answer / sunilchai

Hi Bharat your answer will work if we have low values but I
had come across the situation where I need to connect to
msaccess database where it has nearly 10000 records need to
fetch the records and insert in mysql.Keeping all the
sensitive info in the sessions will exceed the server
session memory

thanks and regards,
sunilchai

Is This Answer Correct ?

2 Yes

3 No

how can we retrive value from one database server and store them another database server using php..

Answer / bharat

Another option is :
we can stored all values in sessions of one database.
and these sessions values insert in to another database.

Is This Answer Correct ?

2 Yes

6 No

Post New Answer