Guest User

Untitled

a guest
Jun 8th, 2018
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.50 KB | None | 0 0
  1. <?php
  2.     $host = "...";
  3.     $username = "...";
  4.     $password = "...";
  5.    
  6.     $backupFile = '../backups/sql/allDatabasesBackup'. date("Y-m-d-H-i-s") . '.sql';
  7.     $command = "mysqldump --opt -h $host -u $username -p $password --all-databases > $backupFile";
  8.     system($command);
  9.  
  10.     /*  File output:
  11.     Usage: mysqldump [OPTIONS] database [tables]
  12.     OR     mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
  13.     OR     mysqldump [OPTIONS] --all-databases [OPTIONS]
  14.     For more options, use mysqldump --help
  15.     */
  16. ?>
Add Comment
Please, Sign In to add comment