reenadak

take dump of mysql database

Feb 21st, 2018
137
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.66 KB | None | 0 0
  1. <?php
  2. $db_user = "****";
  3. $db_pass = "*****";
  4. $db_host = "localhost";
  5. echo "<html>\n<p>Starting database(s) backup at : ". date("Y-m-d H:i:s");
  6.        
  7.         mysql_connect($db_host, $db_user, $db_pass);
  8.         $r = mysql_query("show databases");
  9.         while( $arr = mysql_fetch_array($r))
  10.         {
  11.             $db = $arr[0];
  12.                     echo "\n\n<br>Exporting ".$db." at\n " . format_time() . "\n";
  13.             echo shell_exec("mysqldump  -u ".$db_user." -h ".$db_host." -p".$db_pass." ".$db." | bzip2 > /home/mukesh/md/cron/06_db_backup/db_dump/".date('w')."_".$db.".sql.bz2");
  14.         }
  15.        
  16. echo "\n\n<br>Database backup finished at : ". format_time() . "\n\n</html>"    ;
  17. echo mysql_error();
  18. mysql_close();
  19. ?>
Add Comment
Please, Sign In to add comment