Login   Register  
PHP Classes

File: execute_db_backup.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Vagharshak Tozalakyan  >  MySQL Backup  >  execute_db_backup.php  >  Download  
File: execute_db_backup.php
Role: Example script
Content type: text/plain
Description: Example of usage
Class: MySQL Backup
Backup MySQL databases to files with SQL commands
Author: By
Last change: foo
Date: 8 years ago
Size: 3,174 bytes


Class file image Download
        |    Example MySQL Backup File                      |
        |                                                   |
        |    Written by: Justin Keller <kobenews@cox.net>   |
        |   Released under GNU Public license.             |
        |                                                  |
        |    Only use with MySQL database backup class,     |
        |    version 1.0.0 written by Vagharshak Tozalakyan |
        |    <vagh@armdex.com>.                             |
require_once 'mysql_backup.class.php';
$backup_obj = new MySQL_Backup();
//----------------------- EDIT - REQUIRED SETUP VARIABLES -----------------------
$backup_obj->server 'localhost';
$backup_obj->port 3306;
$backup_obj->username '';
$backup_obj->password '';
$backup_obj->database '';
//Tables you wish to backup. All tables in the database will be backed up if this array is null.
$backup_obj->tables = array();

//------------------------ END - REQUIRED SETUP VARIABLES -----------------------
    //-------------------- OPTIONAL PREFERENCE VARIABLES ---------------------
            //Add DROP TABLE IF EXISTS queries before CREATE TABLE in backup file.
$backup_obj->drop_tables true;
//Only structure of the tables will be backed up if true.
$backup_obj->struct_only false;
//Include comments in backup file if true.
$backup_obj->comments true;
//Directory on the server where the backup file will be placed. Used only if task parameter equals MSB_SAVE.
$backup_obj->backup_dir '/';
//Default file name format.
$backup_obj->fname_format 'm_d_Y';

//--------------------- END - OPTIONAL PREFERENCE VARIABLES ---------------------
    //---------------------- EDIT - REQUIRED EXECUTE VARIABLES ----------------------        
                    MSB_STRING - Return SQL commands as a single output string.
                    MSB_SAVE - Create the backup file on the server.
                    MSB_DOWNLOAD - Download backup file to the user's computer.
//Optional name of backup file if using 'MSB_SAVE' or 'MSB_DOWNLOAD'. If nothing is passed, the default file name format will be used.
$filename '';
//Use GZip compression if using 'MSB_SAVE' or 'MSB_DOWNLOAD'?
$use_gzip true;

//--------------------- END - REQUIRED EXECUTE VARIABLES ----------------------
    //-------------------- NO NEED TO ANYTHING BELOW THIS LINE -------------------- 
if (!$backup_obj->Execute($task$filename$use_gzip))
$output $backup_obj->error;
$output 'Operation Completed Successfully At: <b>' date('g:i:s A') . '</b><i> ( Local Server Time )</i>';
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>MySQL Backup</title>
echo $output;