Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- ini_set('display_errors', 1);
- ini_set('display_startup_errors', 1);
- error_reporting(E_ALL);
- $database = 'database_name';
- $user = 'database_user';
- $pass = 'database_password';
- $host = 'localhost';
- $dir_sql = dirname(__FILE__) . '/dump.sql';
- $dir_zip = dirname(__FILE__) . '/dump.zip';
- exec("mysqldump --user={$user} --password={$pass} --host={$host} {$database} --result-file={$dir} 2>&1", $output);
- // create zip file
- $z = new ZipArchive();
- $z->open($dir_zip, ZIPARCHIVE::CREATE);
- $z->addFile($dir_sql);
- $z->close();
- // remove sql file
- @unlink($dir_sql);
- echo "Backup file created at {$dir_zip}";
Add Comment
Please, Sign In to add comment