How to use mysqldump in php?
I try

<?
`mysqldump -utest -ptest --opt data>/data.sql`;
?>

But this not work...:rolleyes:

Thanks!

mysqldump -uUsername -p Databasename >./file.txt

When you run this, it will ask you for your password and then dump everything into the file "file.txt" in the same directory where you run the command.

I think you can put the password in the command line as well..

mysqldump -uUsername -pPassword Databasename >./file.txt

To run it via PHP you need to use a system call...

e.g.

system("mysqldump -uUsername -pPassword Database >out.sql");

of course you need to put the full path to mysqldump and the full path to where you want the file dumped...

Thanks...:blush:

Just try the script for many many times...
It work well with the shell...but not work at the browser...:rolleyes:

<?
system("/usr/bin/mysqldump databasename -u username -ppassword >path/to/dump/file.sql");
?>

What wrong with my script?
Thanks!

I believe you have the parameters in the wrong order:


<?
system("/usr/bin/mysqldump databasename -u username -ppassword >path/to/dump/file.sql");
?>


Should be:


<?
system("/usr/bin/mysqldump -u username -ppassword databasename >path/to/dump/file.sql");
?>


You might also want to check the return value of the system call.

Frank

Hmm...just check the error log...:)
If I run the php in a browser,
and a file.sql is already here,
the php cannot cover the old one...
I should have another filename.

Or chmod the old database to 666...;)