Full MySQL Database Backup

[trytertqwr]

Hello again guys.

Can someone give me an example / script of how to perform a full MySQL backup in PHP? I've done a Google search and a lot of tutorials, etc look way more complicated than I think they should be. I just want someone to show me how I can get the same results if I were doing an export / dump in PHPMyAdmin.

In the end, I will have the script send the data / file to the browser as a download, but I know how to do that. Just show me how to do it using all those mysql functions.

Thanks in advanced!

[Ravish]

You can backup a MySQL database using the following PHP code:

$backupFile = $databasename . '.gz';

$command = "mysqldump --opt -h $databasehost -u $databaseuser -p $databasepass $databasename | gzip > $backupFile";

system($command);