Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db_user = "****";
- $db_pass = "****";
- $db_host = "*****";
- echo "<html>\n<p>@ ". 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<br>\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<br>@ ". date('Y-m-d H:i:s') . " Database backup completed.\n\n</html>";
- ?>
Add Comment
Please, Sign In to add comment