Location: PHPKode > projects > LibraryManager > include/execute_db_backup.php
<?
	/*
		|--------------------------------------------------|
		|	Example MySQL Backup File                      |
		|	                                               |
		|	Written by: Justin Keller <hide@address.com>   |
		|   Released under GNU Public license.             |
		|                                                  |
		|	Only use with MySQL database backup class,     |
		|	version 1.0.0 written by Vagharshak Tozalakyan |
		|	<hide@address.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 ----------------------		
				
			/*
				Task: 
					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.
					
			*/
			$task = MSB_DOWNLOAD;
			
			//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;
	}
	else
	{
		$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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>MySQL Backup</title>
</head>
<body>
<?
	echo $output;
?>
</body>
</html>
Return current item: LibraryManager