<?php

/**
 * Script backup DB
 * Author: Le Xuan Chien
 * Emai: chien.lexuan@gmail.com
 */
$basePath = dirname(__FILE__).DIRECTORY_SEPARATOR.'backup/';
$backupFile = $basePath.'database_backup_' . date("YmdHis") . '.sql';
$command = 'mysqldump reizedev --password=W0mbat223! --user=reizeuser --single-transaction >' . $backupFile;
$output = array();
exec($command,$output);
print_r($output);
//Create ZIP
$new_archive_name = $basePath."database_backup.zip";
$new_zip = new ZipArchive;
$new_open = $new_zip->open($new_archive_name, ZIPARCHIVE::CREATE);
$new_zip->addFile($backupFile);