title: How to get database backup from online server to offline server using PHP with MySQL
body: <pre><code>//Assume Server 1
  $conn = mysql_connect("127.0.0.1","root","");
  
  //Assume Server 2
  $conn1 = mysql_connect("127.0.0.1","root","");
  
  //Server 1 database
  mysql_select_db("db1",$conn);
  
  //Server 2 database
  mysql_select_db("db2",$conn1);
  
  //Count number of rows from server 1 -&gt; database -&gt; table (tbl1)
  $cnt_rw=mysql_query("select count(*) from db1.tbl1");
  $cnt_n=mysql_fetch_array($cnt_rw);  
  
  //Fetch and update row one by one
  for($i=0;$i&lt;($cnt_n['count(*)']);$i++)
  {
      $one_row=mysql_query("select * from db1.tbl1 limit $i,1");
      while($one_val=mysql_fetch_array($one_row))
      {
          $one=$one_val['one'];
          $two=$one_val['two'];
          $three=$one_val['three'];
      }
  
      //Already exist means update else insert so am using replace query
      mysql_query("REPLACE INTO db2.tbl2(one,two,three)values('".$one."','".$two."','".$three."')");
      $one=$two=$three='';
  }   
  </code></pre>
  
  <p>This PHP code is working properly but take a long loading time. So I want a simple query or PHP/MySQL code or any idea to get backups from the online server to the offline server.</p>
  
  <p>Online and offline database fields are same.</p>