[Resolved] MySQL Backup - kind of working...

[csousley]

I'm writing a script for backing up a mysql database. I've tried a whole bunch of differnet options and can't seem to get it working right. All of these will create the backup file, but with nothing in it, 0kb files. Any thoughts? Thanks

	$path = "../mysql_backup/".date("U")."-".$mversion.".sql";
	system(sprintf("mysqldump -c -h ".$sql_lloc." -u ".$sql_user." -p ".$sql_pass." ".$sql_name." > ".$path));
	//exec("mysqldump -c -h ".$sql_lloc." -u ".$sql_user." -p ".$sql_pass." ".$sql_name." > ".$path);
	//passthru("mysqldump -c -h ".$sql_lloc." -u ".$sql_user." -p ".$sql_pass." ".$sql_name." > ".$path);
	//shell_exec("mysqldump -c -h ".$sql_lloc." -u ".$sql_user." -p ".$sql_pass." ".$sql_name." > ".$path);

[LordShryku]

Well, it's hard to say here. Firsy, it doesn;t look like you're really using sprintf. Second, it doesn't look like you tell it what database to use. Plus, I dunno if half those variables are even defined. All I can really offer you is the script that I made, and hopefully you can take what you need from that. It is used to backup all databases...

<?php
$host      = "";
$user      = "";
$pass      = "";
$backupdir = "/home/mysql/backups";
$backup    = $backupdir."/db_backup_".date("Y-m-d");

system(sprintf("/usr/local/mysql/bin/mysqldump --all-databases -h %s -u %s -p%s > %s.sql",$host,$user,$pass,$backup));
?> 

[csousley]

Thankyou, that works like a champ. I had tried something with that before from an older post of yours and wasn't able to get it to work, must have had something else wrong. Anyway, if anyone is interested in just backing up one DB, here is the string I'm now using.

system(sprintf("/usr/local/mysql/bin/mysqldump $sql_name -h %s -u %s -p%s > %s.sql",$sql_lloc,$sql_user,$sql_pass,$path)); 

Thanks again.