how to fetch data from live servers and insert it into other server
<p>I have two <strong>servers</strong>. The question is i want to select the information form one server's table and insert it into other server's table. for that how many files i need.</p>

<p>I am able to select table data form server one but i don't know how to insert it into server two's table.</p>

<p>can any one help me or give me brief idea which will work</p>

<p>$sql="SELECT * FROM import_address_book LIMIT 0 , 30";
    $result=mysql_query($sql) or die();</p>

<pre><code>while($row=mysql_fetch_array($result))
{
$id = $row[id];
$mobile_no = $row[mobile_no];
$user_id = $row[user_id];
$userEmail = $row[userEmail];
$name = $row[name];
$email = $row[email];
$type = $row[type];
$country = $row[country];
$gpwd = $row[gpwd];
$status = $row[status];
$dateCreated = $row[dateCreated];
$gender = $row[gender];
$city = $row[city];
$income = $row[income];
$profession = $row[profession];
$experience = $row[experience];
$pincode = $row[pincode];
$blacklist = $row[blacklist];

}
</code></pre>

<p>how to insert it in other server</p>
