MySQL database backup using PHP

Question

I have used the following to check if exec() is enabled on my server:

public function exec_enabled() {
  $disabled = explode(',', ini_get('disable_functions'));
  return !in_array('exec', $disabled);
}

And I found out that it was enabled on my server. Now I am trying to run the following, and the database isn't getting backed up:

exec('mysqldump --user=foo --password=bar --host=localhost foobar > backup.sql');

I have also tried

exec('mysqldump -u foo -p bar foobar > backup.sql');

But it didn't work either. Also, I am not getting any errors (error reporting is on). Can anyone please tell me what am I doing wrong here?

Try this `exec('mysqldump -ufoo -pbar foobar > backup.sql');`. Don't leave space after user and password — user3004356, Feb 20 '14 at 11:12
use `system("mysqldump -ufoo -pbar foobar > backup.sql");` instead of exec. — user3004356, Feb 20 '14 at 11:16
Already tried that dear. I have posted this after trying with `exec()`, `shell_exec()` and `system()` — Kamran Ahmed, Feb 20 '14 at 11:17
exec("/usr/bin/mysqldump -uusername-ppassword databasename | gzip -9 > /path/to/backupfile.gz"); for linux — Sathish D, Feb 20 '14 at 11:18
possible duplicate of [Export MySQL database using PHP only](http://stackoverflow.com/questions/22195493/export-mysql-database-using-php-only) — T.Todua, Dec 24 '14 at 18:42

score 0 · Answer 1 · edited Feb 20 '14 at 11:44

0

Syntax:

mysqldump -u username -ppass_word database_name table_name > path/sql_file_name.sql

edited Feb 20 '14 at 11:44

nKn

13,691
9
45
62

answered Feb 20 '14 at 11:20

Mahavir

322
4
8

The -p option tells MySQL to prompt for a password – CS GO Feb 20 '14 at 11:28

score 0 · Answer 2 · answered Feb 20 '14 at 11:23

0

This should work -

exec('mysqldump -u foo --password=bar --host=localhost foobar > backup.sql');

answered Feb 20 '14 at 11:23

CS GO

914
6
20

score 0 · Answer 3 · answered Feb 20 '14 at 11:31

In *nix systems, use the WHICH command to show the location of the mysqldump, try this :

<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$dbname = 'test';
$mysqldump=exec('which mysqldump');

$backup_file = $dbname .'.gz';
$command = "$mysqldump --opt -h $dbhost -u $dbuser -p $dbpass ".
           "test_db | gzip > $backup_file";

exec($command);
?>

score 0 · Answer 4 · edited Jul 02 '15 at 16:01

0

putting the complete path to mysql dump seems to work

exec('complete\path\to\mysqldump.exe -uUSERNAME -pPASSWORD DATABASE_NAME > output_folder_path/filename.sql');

edited Jul 02 '15 at 16:01

Félix Adriyel Gagnon-Grenier

8,422
10
52
65

answered Jul 02 '15 at 14:27

naikjeevan91

1
3

MySQL database backup using PHP

4 Answers4