₦airaland Forum

Help Nlander's I just developed an intranet application for a client with PHP and using MYSQL as the backend  database.
My problem is Backing it up automatically, I tried using this Script but

$username = "my_username";  //database username
$password = "password"; //database password
$hostname = "localhost"; //database host localhost
$database = "clients_database"; //my database name

$username =escapeshellcmd($username);//esscaping for shell command
$password =escapeshellcmd($password);
$hostname =escapeshellcmd($hostname);
$database =escapeshellcmd($database);
$backupFile= dir(_FILE_).$database.'.sql'; //name of the backup file
$command = "mysqldump --user=$username --password=$password --host=$hostname $database > $backupFile"; //backingup command
system($command, $result);  //running the command

Every time I run the code the result file is always empty even there is data in the database
Help Guys what is wrong with my code?

Guys wainting for your reply

All those codes that are working with shell command tend to misbehave on windows sometimes, i think they were meant to work properly for linux.
I once had that kinda problem before. Well, i once did something like that - but the script was lost due to carelessness - after searching the web
endlessly, i could not find a satisfactory one, i made it for an intranet application too.
You may consider using an msdos batch file to backup the database file directly. . .

Thanks Big Boss, I never tought of that. Gracias

Thanks Big Boss, I never tought of that. I am going tu try that sharp sharp. Gracias

You can take a look at this - http://www.phpclasses.org/package/4017-PHP-Backup-large-MySQL-databases-into-multiple-files.html

I am still checking my backups for that script i wrote earlier, if i can find it, i will post it here. Funny, i never got down to using it after
i finished creating it. But this phpclasses.org script seem familiar - i must have used it before