使用PHP / MYSQL备份整个数据库

Question

I am trying to perform php/mysql backups

I receive values from a form page and then with the command "select tables", i save those values in a array.

After that i do a "for" loop to backup each table:

<?php

$dbname = $_POST['txt_db_name'];
$tbname = $_POST['txt_tb_name'];

$ligacao=mysql_connect('localhost','root','')
or die ('Problemas na ligação ao Servidor de MySQL');

$res = mysql_query("SHOW TABLES FROM pessoal");

$tables = array();

mysql_select_db($dbname,$ligacao);

while($row = mysql_fetch_array($res, MYSQL_NUM)) {
$tables[] = "$row[0]";
}

$length = count($tables);


for ($i = 0; $i < $length; $i++) {
$query=
"SELECT * INTO OUTFILE 'pessoa_Out.txt'".
"FIELDS TERMINATED BY ',' ".
"ENCLOSED BY '\"'".
"LINES TERMINATED BY '#'".
"FROM $tables[$i]";


 $resultado = mysql_query($query,$ligacao);

 }



 mysql_close();

 if ($resultado) 
 $msg ='Sucesso na Exportaçao da Database '.$dbname.' ';
 else
 $msg ='Erro Impossivel Exportar a Database '.$tbname.' ';

 ?>

Answer 1

Don't do this — you are re-inventing existing tools!

Invoke mysqldump instead, which is expressly designed for the purpose.

With the proper permissions, you can use PHP's system or exec to invoke this.