title: PHP export MySQL tables to SQL file
body: <p>I am trying to run this php code:</p>
  
  <pre><code>&lt;?php
      $sql="SHOW tables from integra_integra ";
      $rs=mysql_query($sql,$conn);
  
      while($result=mysql_fetch_array($rs))
      {
          $backupFile='A_Backups_Full/'.$result[0].'.sql';
          $sql2="SELECT * INTO OUTFILE '$backupFile' from '".$result[0]."' ";
          $result2=mysql_query($sql2,$conn);
  
          echo $result[0].' '.$backupFile.'&lt;br&gt;&lt;br&gt;';
      }
  ?&gt;
  </code></pre>
  
  <p>It selects all tables from a database and then runs a query to export each table to an sql file</p>
  
  <p>When I echo the data, it displays fine so I know there is no problem there but it's not saving the .sql files. </p>
  
  <p>I have given the directory they are saving to full access</p>