Mysql PHP backup database using mysqldump

Question

I try to create a backup for my database. My database is MySQL. I am using PHP. I use a cron job to execute this code every hour.

This is my code:

$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbname='stock';
$backup_file = $dbname . date("Y-m-d-H-i-s") . '.sql';
$command = "mysqldump --opt -h $dbhost -u $dbuser -p $dbpass ". "stock | gzip > $backup_file";
system($command);

The problem is that my code give me an empty file How can i have my all database ?!

Possible duplicate of [Automated or regular backup of mysql data](http://stackoverflow.com/questions/38916163/automated-or-regular-backup-of-mysql-data) — e4c5, Feb 17 '17 at 07:04

score 1 · Answer 1 · edited May 23 '17 at 12:16

I also encounter same problem/situation years back. Refer here. Here are a few things that need to TAKE NOTE:-

Compulsory to use absolute path for MySQL dump.
Try using --opt (default option for MySQL dump). Can refer http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
For the option, if use short form, no need to have (--). eg: --p. Use (--) when using full form. eg: --password. So use '-p' instead of '--p' (applied for others option too).
try 'shell_exec' or 'system' if MySQL dump doesn't work on 'exec'.
try to avoid have space between option and variable. Eg: -p$dbpass

*Also bear in mind, it involves with permission whether system command can be executed from PHP or not.

Thank you so much for solving my issues! – Igor Unger Feb 25 '17 at 20:16 — Igor Unger, Feb 25 '17 at 20:16

Mysql PHP backup database using mysqldump

1 Answers1

Linked