Backup database with PHP - mysqldump

Question

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

My backup file ends up being an empty zero byte file.

My authentication and connection details are correct.

I enabled error reporting - no errors.

Server is running PHP 5.6.

catch errors with proc_open(), or redirect stderr to some file: mysqldump ... | gzip > file 2>error.log — Ruslan Osmanov
– Ruslan Osmanov, Commented May 5, 2016 at 9:28

Ruslan Osmanov · Accepted Answer · 2016-05-05 09:43:12Z

2

According to mysqldump documentation, you shouldn't put space between -p and password:

· --password[=password], -p[password]

The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the option and the password. If you omit the password value following the --password or -p option on the command line, mysqldump prompts for one.

edited May 5, 2016 at 9:43

answered May 5, 2016 at 9:34

Ruslan Osmanov

21.8k8 gold badges52 silver badges62 bronze badges

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

1 Comment

Cody Raspien Over a year ago

Thank you. I removed the space and it worked: $command = "mysqldump --opt -h $dbhost -u $dbuser -p$dbpass $dbname | gzip > $backupFile";

Dr Fred · Accepted Answer · 2016-08-09 12:44:40Z

0

When calling mysqldump from PHP you may need to write the executable full path (ie : '/usr/local/mysql-5.1.52-osx10.6-x86_64/bin/mysqldump' instead of 'mysqldump')

answered Aug 9, 2016 at 12:44

Dr Fred

9899 silver badges15 bronze badges

Collectives™ on Stack Overflow

Backup database with PHP - mysqldump

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related