reenadak

take backup of MySql databases via php

Sep 25th, 2017
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.85 KB | None | 0 0
  1. <?php
  2. $db_user = "****";
  3. $db_pass = "****";
  4. $db_host = "*****";
  5. echo "<html>\n<p>@ ". date('Y-m-d H:i:s') . " Database backup started.";
  6.  
  7. $sql="SHOW DATABASES";
  8. $link = mysqli_connect($db_host,$db_user,$db_pass) or die ('Error connecting to mysql: ' . mysqli_error($link).'\r\n');
  9.  
  10. if (!($result=mysqli_query($link,$sql))){
  11.         printf("Error: %s\n", mysqli_error($link));
  12. }
  13.  
  14. while( $row = mysqli_fetch_row( $result ) )
  15. {
  16.     if (($row[0]!="information_schema") && ($row[0]!="mysql"))
  17.     {
  18.         echo "\n\n<br>\n@ " . date('Y-m-d H:i:s') . " Exporting ".$row[0]." \n";
  19.         $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";                  
  20.         system($output);   
  21.     }
  22. }
  23.            
  24. echo "\n\n<br>@ ". date('Y-m-d H:i:s') . " Database backup completed.\n\n</html>";
  25. ?>
Add Comment
Please, Sign In to add comment