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

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
publigroup
Forum Newbie
Posts: 1
Joined: Mon May 16, 2005 8:21 am

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

Post 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?
User avatar
Wayne
Forum Contributor
Posts: 339
Joined: Wed Jun 05, 2002 10:59 am

Post by Wayne »

you need to quote the column names for the variables

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