@ ". date('Y-m-d H:i:s') . " Database backup started."; $sql="SHOW DATABASES"; $link = mysqli_connect($db_host,$db_user,$db_pass) or die ('Error connecting to mysql: ' . mysqli_error($link).'\r\n'); if (!($result=mysqli_query($link,$sql))){ printf("Error: %s\n", mysqli_error($link)); } while( $row = mysqli_fetch_row( $result ) ) { if (($row[0]!="information_schema") && ($row[0]!="mysql")) { echo "\n\n
\n@ " . date('Y-m-d H:i:s') . " Exporting ".$row[0]." \n"; $output = "mysqldump --opt -u ".$db_user." -h ".$db_host." -p".$db_pass." ".$row[0]." | bzip2 > /home/reenain/md/cron/01_db_backup/".$row[0].".sql.bz2"; system($output); } } echo "\n\n
@ ". date('Y-m-d H:i:s') . " Database backup completed.\n\n"; ?>