Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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&#8243;, $db1);
$res1 = mysql_query(”query”,$db1);
$db2 = mysql_connect(”host”,”user”,”pwd”)
mysql_select_db(”db2&#8243;, $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&#8243;, $db1);
$res1 = mysql_query(”query”,$db1);

$db2 = mysql_connect(”host”,”user”,”pwd”, true)
mysql_select_db(”db2&#8243;, $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

Tell me what is the use of the function htmlentities?

0 Answers  


Is php used in 2019?

0 Answers  


How to initiate a session in php?

0 Answers  


Questions on OOP concepts 1. What are the access specifiers available in php ? Explain 2. What is object cloning ? 3. What are the differences between interface and abstract class ? 4. What is overloading ? 5. What is overriding ? 6. How to prevent function overriding ? 7. What is the use of "final" keyword ? 8. What is static variable ? How will access a static variable ? What is static class ?

2 Answers   IPMC, NIIT,


What are the ways to define a constant in php?

0 Answers  


Tell me what is mean by an associative array?

0 Answers  


What are the differences between php3 and php4 and php5? What is the current stable version of php? What advance thing in php7?

0 Answers  


Write the code for upload a video file in PHP.How will You Play this in Your Page.?

2 Answers   ASD Lab, Convex Digital,


Where are the persistent cookies stored on your computer?

0 Answers  


What is the difference between nowdoc and heredoc?

0 Answers  


How to remove values saved in the current session?

0 Answers  


how to store case sensitive data in mysql ? how repair mysql table? diff bet float, double,real? diff bet mysql_fetch_object() and mysql_fetch_array()? which version of mysql support procedure , trigger? diff php4 and php 5? op - 2+5+"8"=? how to create object in javascript? query - select games from team who won games 2/4/6? NaN command in php? How to offload System date in mysql? typecasting in php? how to convert string to two decimal no? how to parse xml file in php command line argument in php? diff bet $msg,$$msg? diff bet require(), include(), include_once()? tables in mysql?

2 Answers   Aloha Technology,


Categories