backup mltpl mysql databases (system() doesn't wrk in loop)
Posted: Mon May 16, 2005 8:33 am
/* 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?
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?