MySQL database restore using PHP

Question

I'm trying to restore MySQL dump created the following way:

$file = '/path/to/file.sql';
exec('mysqldump -u '.DB_USER.' -p'.DB_PASS.' '.DB_NAME.' > '.$file);

the above creates the dump as expected, then to restore I'm trying to use the following:

$file = '/path/to/file.sql';
exec('mysql -u '.DB_USER.' -p'.DB_PASS.' '.DB_NAME.' < '.$file);

but for some reason it doesn't do anything.

Please note that the constants contain the relevant database connection parameters.

Any idea what I'm doing wrong?

try the full path of mysql, like /usr/bin/mysql or whatever and add some error checking on the exec call. debug info? — sdolgy
– sdolgy, Commented May 6, 2011 at 18:22
Have you tested the string produced by PHP in a MySQL client connection to make sure it works? — OMG Ponies
– OMG Ponies, Commented May 6, 2011 at 18:25

chx · Accepted Answer · 2011-05-06 18:26:47Z

1

use mysql -e 'source $file' instead of redirection

answered May 6, 2011 at 18:26

chx

11.9k8 gold badges64 silver badges144 bronze badges

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

Comments

MacMac · Accepted Answer · 2011-05-06 18:27:51Z

0

$file = realpath('file.sql');
exec('mysqldump -u ' . DB_USER . ' -p' . DB_PASS . ' ' . DB_NAME . ' > ' . $file);

Perhaps try this.

answered May 6, 2011 at 18:27

MacMac

35.5k55 gold badges153 silver badges224 bronze badges