* This file contains the Backup_Database class wich performs * a partial or complete backup of any given MySQL database * @author Daniel López Azaña <http://www.daniloaz.com> * @version 1.0 * http://www.daniloaz.com/en/560/programming/backup-de-bases-de-datos-mysql-con-php/ */ /** * Define database parameters here */ define("OUTPUT_DIR", '../unused/sqldmp'); define("TABLES", '*'); /** * Instantiate Backup_Database and perform backup */ $backupDatabase = new Backup_Database(SERVER, USERNAME, PASSWORD, DATABASE); $status = $backupDatabase->backupTables(TABLES, OUTPUT_DIR) ? 'OK' : 'KO'; echo "<br /><br /><br />Backup result: " . $status; /** * The Backup_Database class */ class Backup_Database { /** * Host where database is located */ var $host = ''; /** * Username used to connect to database */ var $username = ''; /**
<?php require_once './conexion.php'; $usuario = 'root'; $password = ''; $db = 'db_farmacia'; $local = 'localhost'; $tables = '*'; $dir = 'd:backup'; /** * Instantiate Backup_Database and perform backup */ $backupDatabase = new Backup_Database($local, $usuario, $password, $db); $status = $backupDatabase->backupTables($tables, $dir) ? 'OK' : 'KO'; echo "\n\n\nBackup result: " . $status; /** * The Backup_Database class */ class Backup_Database { /** * Host where database is located */ var $host = ''; /** * Username used to connect to database */ var $username = ''; /** * Password used to connect to database */
protected function saveFile(&$sql, $outputDir = '.') { if (!$sql) { return false; } try { $handle = fopen($outputDir . '/' . $this->dbName . '-' . date("dmY-His") . '.sql', 'w+'); fwrite($handle, $sql); fclose($handle); } catch (Exception $e) { var_dump($e->getMessage()); return false; } return true; } } /** * Instantiate Backup_Database and perform backup */ $backupDatabase = new Backup_Database(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); $status = $backupDatabase->backupTables(TABLES, OUTPUT_DIR) ? 'Concluído' : 'ERRO'; echo "\n<hr/><p>\nBackup " . $status . '!'; echo '<p>Salvo em : <b>' . OUTPUT_DIR . '</b></p>'; echo '<br/>'; echo '<a href="principal.php" class="btn btn-success">Voltar</a>'; } else { header('Location: principal.php'); } if ($_SESSION["logado"] == false) { header('Location: logout.php'); }
$sendMailer->AddAddress('*****@*****.**'); //$sendMailer->AddAddress('*****@*****.**'); $sendMailer->Subject = "Daily Sales Email Report"; $sendMailer->IsHTML(true); $sendMailer->Body = date('d/m/Y H:i:s') . "\n<table border='0'>\n<tr>\n\t<td>Daily </td><td>:</td><td style='font-family:courier new; text-align:right;'>{$sales['d']}</td>\n</tr>\n<tr>\n\t<td>Weekly </td><td>:</td><td style='font-family:courier new; text-align:right;'>{$sales['w']}</td>\n</tr>\n<tr>\n\t<td>Monthly</td><td>:</td><td style='font-family:courier new; text-align:right;'>{$sales['m']}</td>\n</tr>\n<tr>\n\t<td>Yearly </td><td>:</td><td style='font-family:courier new; text-align:right;'>{$sales['y']}</td>\n</tr>\n</table>"; $result['mailsales'] = 'sending'; try { $sent = $sendMailer->Send(); if ($sent) { $result['mailsales'] = 'sending success'; $result['text'] .= ' sales figure sent.'; } else { $result['mailsales'] = 'sending failed'; } } catch (phpmailerException $e) { $result['mailsales'] = $e->errorMessage(); } catch (Exception $e) { $result['mailsales'] = $e->getMessage(); } if (!$result['exists']) { include 'mysql-backup.php'; $dbbackup = new Backup_Database($server, $user, $pass, $db, 'utf-8'); $status = $dbbackup->backupTables('*', 'localhost', $backupname, $log); $result['result'] = $status; } else { $result['result'] = false; } if (!$log) { header('Content-type: application/json'); } echo json_encode($result);
<?php define("DB_USER", 'root'); define("DB_PASSWORD", ''); define("DB_NAME", 'be'); define("DB_HOST", 'localhost'); define("TABLES", '*'); $backupDatabase = new Backup_Database(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); $backupDatabase->backupTables(TABLES); class Backup_Database { var $host = 'localhost'; var $username = '******'; var $passwd = ''; var $dbName = 'be'; var $charset = ''; //set variables to connect to database function Backup_Database($host, $username, $passwd, $dbName, $charset = 'utf8') { $this->host = $host; $this->username = $username; $this->passwd = $passwd; $this->dbName = $dbName; $this->charset = $charset; $this->initializeDatabase(); } //connect to database protected function initializeDatabase() { $conn = mysql_connect($this->host, $this->username, $this->passwd); mysql_select_db($this->dbName, $conn);