Mysql backup using php script

I want to make php script which will take backup of mysql database. I dont want to use phpmyadmin, I want using it php script. Is it possible to execute mysqldump command using php?

Thanks in advance

 

This might be of great interest to you : http://www.phpmybackuppro.net/

 

Yes , this dude Joe has done it

http://www.krakjoe.info/

Look on the right there...

 

rsnapshot has one written in Perl - could easily convert it to php.

 

This is what I have been using for years.

<?

function backupDBs(){

  $link = mysql_connect("localhost","root","PASSWORD");
  $result = mysql_query("show databases", $link);

  while($row = mysql_fetch_assoc($result)) {
    mysql_query("use ".$row["Database"], $link);
    $resultTables = mysql_query("show tables");
    while($rowTables = mysql_fetch_assoc($resultTables)) {
      system("mysqldump --user=root --password=PASSWORD ".$row["Database"]." ".$rowTables["Tables_in_".$row["Database"]]." > /var/www/dbBackups/".date("mdY")."_".$row["Database"]."_".$rowTables["Tables_in_".$row["Database"]].".sql");
    }
  }

  system("tar --create --gzip --file /var/www/dbBackups/".date("mdY").".tar.gz /var/www/dbBackups/*.sql");
  system("rm -f /var/www/dbBackups/*.sql");
  system("mv /var/www/dbBackups/*.gz /mnt/zip/db_tables/".date("m")."/");
}

function backupWWW(){
  system("cp -uR --reply=yes /var/www/html /mnt/zip/www");
  system("cp -uR --reply=yes /var/www/php-includes /mnt/zip/www");
}

if(date("d") == 01){

  // perform 1st of month mtce
  // rm -f current months directory
  system("rm -f /mnt/zip/db_tables/".date("d")."/*");

  // run backup routine
  backupDBs();
  backupWWW();
} else {

  backupDBs();
  backupWWW();
}

?>

PHP:

 

Well technically, phpMyAdmin is a php script

 

Thanks a lot EviLive....
Will try this script today itself....
I was also looking for this....