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 — e4c5
– e4c5, Commented Feb 17, 2017 at 7:04

Community · Accepted Answer · 2017-05-23 12:16:51Z

1

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.

edited May 23, 2017 at 12:16

CommunityBot

11 silver badge

answered Feb 17, 2017 at 8:25

Salehin Rafi

3512 gold badges6 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mysql PHP backup database using mysqldump

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related