How to take database backup from PHP

sachindesarda

I want to take backup of mysql database from php file
Normal shell command is
mysqldump --opt database > backup-file.sql
and for taking a backup with password is
mysqldump -p database > backup-file.sql

So when i give the above shell command it asks for a password when i gives the password it do the rest of things.

Now i have to do it from PHP

so i have shell_exec("mysqldump -p database > backup-file.sql")

but then how should i give the password is there any way in PHP to do this.

Natty_Dreadlock

u can also use phpMyAdmin to backup your db... if u rely on the prog u use, check http://de2.php.net/popen

sachindesarda

I have to do it from program it self and i do not understand how popen will help to do this.
The thing is that when i give
mysqldump -p database > backup-file.sql
on shell prompt it will ask me for password .
How can I handle this situation from program.

scoppc

mysqldump -u username -pPASSWORD database > filename.sql

example:

mysqldump -u root -prootp4ssW0rd phpbuilder > backup20062003.sql

sachindesarda

Thanks scoppc,
do u have any idea if i want to take forceful backup then how should i do that.
I has given
mysqldump -f database >backup.sql

But it shows me sql error for the table.
Actually i want to proceed even if sql erroroccurs.
It should eliminate that and should continue with backup.
Is there any way to do this?