How can I retrieve values from one database server and store
them in other database server using PHP?

Answers were Sorted based on User's Feedback



How can I retrieve values from one database server and store them in other database server using PH..

Answer / vijaya

we can always fetch from one database and rewrite to
another. Here is a nice solution of it.

$db1 = mysql_connect(”host”,”user”,”pwd”)
mysql_select_db(”db1″, $db1);
$res1 = mysql_query(”query”,$db1);
$db2 = mysql_connect(”host”,”user”,”pwd”)
mysql_select_db(”db2″, $db2);
$res2 = mysql_query(”query”,$db2);At this point you can only
fetch records from you previous ResultSet,

i.e $res1 - But you cannot execute new query in $db1, even
if you supply the link as because the link was overwritten
by the new db.so at this point the following script will fail

$res3 = mysql_query(”query”,$db1); //this will failSo how to
solve that?

Take a look below.

$db1 = mysql_connect(”host”,”user”,”pwd”)
mysql_select_db(”db1″, $db1);
$res1 = mysql_query(”query”,$db1);

$db2 = mysql_connect(”host”,”user”,”pwd”, true)
mysql_select_db(”db2″, $db2);
$res2 = mysql_query(”query”,$db2);

So mysql_connect has another optional boolean parameter
which indicates whether a link will be created or not. as we
connect to the $db2 with this optional parameter set to
‘true’, so both link will remain live.

now the following query will execute successfully.
$res3 = mysql_query(”query”,$db1);

Is This Answer Correct ?    14 Yes 4 No

How can I retrieve values from one database server and store them in other database server using PH..

Answer / ravinder

by using import and export

Is This Answer Correct ?    1 Yes 15 No

Post New Answer

More PHP Interview Questions

Which is the best method to fetch the data from mysql? 1.mysql_fetch_array() 2.mysql_fetch_object() 3.mysql_fetch_row() 4.mysql_fetch_assoc()

6 Answers  


what is session_set_save_handler in PHP?

0 Answers  


How to get the http request in php?

0 Answers  


How would you determine the size of a file in php?

0 Answers  


Will php die?

0 Answers  


Explain what does $_files means?

0 Answers  


Write a program in php to find the occurrence of a word in a string?

0 Answers  


Is null check in php?

0 Answers  


What is PEAR in PHP?

3 Answers  


What is a static method php?

0 Answers  


What is the meaning of symbol '$' in jquery?

0 Answers  


Explain the difference between mysql_connect and mysql_pconnect?

0 Answers  


Categories