Page 1 of 1

backup mltpl mysql databases (system() doesn't wrk in loop)

Posted: Mon May 16, 2005 8:33 am
by publigroup
/* OPTION 1 doesn't work (but I need to backup a lot of mysql databases) he write 1 sql file, but it's empty (if I user option 2 (single backup)) it works fine

db_connect();

$query = "SELECT * FROM servers WHERE user = 'pporder'";
$result = @mysql_query($query);
while ($row = mysql_fetch_array($result)) {
$host = $row[host];
$user = $row[user];
$pass = $row[pass];
$db = $row[database];
system("mysqldump --opt -h $host -u $user -p$pass $db > $dr/backup/sql/$user-$year$month$day-$hour$min.sql");
print("backuped $host $user $db <br>\n");
}

db_disconnect();


//OPTION 2 WORKS FINE (But I need option 1 to work)

$host= 'localhost';
$user= 'pporder';
$pass= 'publiMASTER';
$db= '--all-databases';

echo '+DONE';
system("mysqldump --opt -h $host -u $user -p$pass $db > $dr/backup/sql/$user-$year$month$day-$hour$min.sql");


//can somebody help me please?

Posted: Mon May 16, 2005 9:44 am
by Wayne
you need to quote the column names for the variables

$host = $row["host"];
$user = $row["user"];
$pass = $row["pass"];
$db = $row["database"];