Backup Site and Database in Codeigniter

8 Comments.
Codeigniter PHP 

Introduction

We will see how to backup site and database in Codeigniter. In the world of web it is important to take backup of our site and database frequently. We don’t know when we’d come across unexpected situation which causes our site stop working. Here I have developed an application in Codeigniter, which will help you to take backup as per your wish whenever you want to take backup. While most web hosting company do a daily backup of a customer’s database and site, relying on them to make backups and provide them at no cost is risky also.

Never take chances when your website is on the line. Make frequent backups !

If you do not want it to use with Codeigniter you could also use it in simple PHP application and for that you just need to understand the logic carefully so that you can convert the code into equivalent PHP.

Prerequisites

Apache 2.4 http server, PHP 7.3.5, Codeigniter 3.1.10, MySQL 5.6

Note I have used md5() for encrypting some values. It’s up to you which algorithm you want to use.

Example with Source Code

Please go through the below sections for coding example on how to take backup site and database using COdeigniter.

Creating MySQL Tables

First thing is we need to create database tables.

The below backup table holds the information for backup:

CREATE TABLE `backup` (
	`backup_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
	`backup_name` varchar(255) NOT NULL,
	`backup_location` varchar(255) NOT NULL,
	`created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (`backup_id`),
	UNIQUE KEY `backup_name_UNIQUE` (`backup_name`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

The below session table holds session information for each client:

CREATE TABLE `session` (
    `id` varchar(45) NOT NULL,
    `ip_address` varchar(20) NOT NULL,
    `timestamp` int(10) unsigned DEFAULT 0 NOT NULL,
    `data` blob NOT NULL,
    KEY `ci_sessions_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

If you do not want to save the session information then you can use default session storage mechanism – file system. To use default session storage mechanism you just need to specify the physical path for sess_save_path in application/config/config.php file. For example, if you want to save into application/cache directory then set as sess_save_path = APPPATH . 'cache/';

Creating Directory – assets

Create assets directory, where css, images and js files will reside, at the root level i.e. parallel to application directory as shown into the picture.

Codeigniter site and database backup

Download images from the below link and put into assets/images directory

codeigniter_backup_images

Creating Directory – backups

Create backups/databases and backups/sites directory which will hold the backups for databases and sites correspondingly as shown below picture

Codeigniter site and database backup

Database Configurations

Configure database settings at location application/config/database.php.

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'blog';
$db['default']['dbdriver'] = 'mysqli';

Session Configuration

Modify the config.php file at location application/config/config.php for session.

I am not using index.php file in URL so you can go through tutorial how to remove index.php from URL in Codeigniter

$config['index_page'] = '';
$config['encryption_key'] = '2d8+e6]K0?ocWp7&`K)>6Ky"|.x|%nuwafC~S/+6_mZI9/17y=sKKG.;Tt}k';
$config['sess_driver'] = 'database';
$config['sess_save_path'] = 'session';

Autoload Configuration

Modify the autoload.php file at location application/config/autoload.php to auto-load few drivers and helpers to avoid repeated loading such things.

$autoload['libraries'] = array('database', 'session');
$autoload['helper'] = array('url', 'file', 'text', 'form');

Creating View File

This view gives the presentation how the inputs will be available to the end users.

<!DOCTYPE html>
<html>
<head>
	<style type="text/css">
		.h_title{
			background: url(assets/images/bg_box_head.jpg) repeat-x;
			color: #bebebe;
			cursor: pointer;
			font-size: 14px;
			font-weight: normal;
			height: 22px;
			padding: 7px 0 0 15px;
			text-shadow: #0E0E0E 0px 1px 1px;
		}

		.message_box {
			margin-top: 10px;
		}

		.error, .success {
			/*padding: 20px 20px 20px 40px;*/
			max-width: 525px;
			margin: auto;
			padding: 10px 10px 10px 45px;
			margin-bottom: 5px;
			border-style: solid;
			border-width: 1px;
			background-position: 10px 10px;
			background-repeat: no-repeat;
		}

		.error {
			background-color: #f5dfdf;
			background-image: url(assets/images/error.png);
			border-color: #ce9e9e;
		}

		.success {
			background-color: #e8f5df;
			background-image: url(assets/images/success.png);
			border-color: #9ece9e;
		}
	</style>
</head>
<body>
	<div class="h_title">
		Codeigniter Site and Database Backup
	</div>
	<div class="message_box">
	<?php
		if (isset($success) && strlen($success)) {
			echo '<div class="success">';
			echo '<p>' . $success . '</p>';
			echo '</div>';
		}

		if (isset($errors) && strlen($errors)) {
			echo '<div class="error">';
			echo '<p>' . $errors . '</p>';
			echo '</div>';
		}

		if (validation_errors()) {
			echo validation_errors('<div class="error">', '</div>');
		}
	?>
	</div>
	<?php
		$back_url = $this->uri->uri_string();
		$key = 'referrer_url_key';
		$this->session->set_flashdata($key, $back_url);
	?>
	<div class="body body-s">
	<?php
		echo form_open($this->uri->uri_string());
	?>
	<fieldset>
		<section>
			<label>Backup Type</label>
			<label>
				<select name="backup_type">
				<option value="" selected disabled>Backup Type</option>
				<option value="1" <?php echo (isset($success) && strlen($success) ? '' : (set_value('backup_type') == '1' ? 'selected' : '')) ?>>DB Backup</option>
				<option value="2" <?php echo (isset($success) && strlen($success) ? '' : (set_value('backup_type') == '2' ? 'selected' : '')) ?>>Site Backup</option>
				</select>
			</label>
		</section>

		<section>
			<label>File Type</label>
			<label>
			<select name="file_type">
				<option value="" selected disabled>File Type</option>
				<option value="1" <?php echo (isset($success) && strlen($success) ? '' : (set_value('file_type') == 1 ? 'selected' : '')) ?>>ZIP</option>
				<option value="2" <?php echo (isset($success) && strlen($success) ? '' : (set_value('file_type') == 2 ? 'selected' : '')) ?>>GZIP</option>
			</select>
			</label>
		</section>
	</fieldset>

	<footer>
		<button type="submit" name="backup" value="backup" class="button">Get Backup</button>
	</footer>
	<?php
		echo form_close();
	?>
	</div>
</body>
</html>

Creating Model Class

This model is responsible for saving backup to databse and deleting backup from database.

<?php

if (!defined('BASEPATH'))
	exit('No direct script access allowed');

/**
* Description of backup_model
*
* @author https://www.roytuts.com
*/
class Backup_model extends CI_Model {

	private $backup = 'backup';

	/**
	* save backup details
	*
	* @return boolean
	*/
	function save_backup_details($file_name, $file_path) {
		$this->db->trans_start();
		$data = array(
			'backup_name' => $file_name,
			'backup_location' => $file_path,
			'created_date' => date('Y-m-d H:i:s')
		);
		
		$this->db->insert($this->backup, $data);
		$id = $this->db->insert_id();
		$this->db->trans_complete();
		
		if ($this->db->trans_status() === FALSE) {
			$this->db->trans_rollback();
			return NULL;
		} else {
			$this->db->trans_commit();
			return $id;
		}
		return NULL;
	}

	/**
	* delete db backup file
	*
	* @return boolean
	*/
	function delete_db_file($file_id) {
		$this->db->trans_start();
		$this->db->where('backup_id', $file_id);
		$query = $this->db->get($this->backup);
		$temp = $query->row();
		$this->db->where('backup_id', $file_id);
		$this->db->delete($this->backup);
		
		if ($this->db->trans_status() === FALSE) {
			$this->db->trans_rollback();
			return NULL;
		} else {
			$this->db->trans_commit();
			return $temp;
		}
	}

	/**
	* check file exists in db
	*
	* @return boolean
	*/
	function check_db_file($file_id) {
		$this->db->where('backup_id', $file_id);
		$this->db->limit(1);
		$query = $this->db->get($this->backup);
		
		if ($query->num_rows() == 1) {
			return $query->row();
		}
		return NULL;
	}

	/**
	* check file exists in db
	*
	* @return boolean
	*/
	function check_site_file($file_id) {
		$this->db->where('backup_id', $file_id);
		$this->db->limit(1);
		$query = $this->db->get($this->backup);
		
		if ($query->num_rows() == 1) {
			return $query->row();
		} else {
			return NULL;
		}
	}

	/**
	* delete site backup file
	*
	* @return boolean
	*/
	function delete_site_file($file_id) {
		$this->db->trans_start();
		$this->db->where('backup_id', $file_id);
		$query = $this->db->get($this->backup);
		$temp = $query->row();
		$this->db->where('backup_id', $file_id);
		$this->db->delete($this->backup);
		
		if ($this->db->trans_status() === FALSE) {
			$this->db->trans_rollback();
			return NULL;
		} else {
			$this->db->trans_commit();
			return $temp;
		}
	}

}

/* End of file backup_model.php */
/* Location: ./application/models/Backup_Model.php */

Creating Controller Class

This controller does everything for you like taking backup, downloading backup, deleting backup, saving backup to database, saving backup to disk space etc.

<?php

if (!defined('BASEPATH'))
	exit('No direct script access allowed');

/**
*
* @author https://www.roytuts.com
*/
class Backup extends CI_Controller {

	/**
	* error messages
	*/
	private $error;

	/**
	* success messages
	*/
	private $success;

	/**
	* base path or root directory of the site i.e. <drive>:/<folder>/<folder>/ or /<folder>/<folder>/
	*/
	public $base_path = "";

	/**
	* folder names to backup that are in the same directory as the CI index.php
	* these can either be just 1 folder name "application" or a path like "application/controllers"
	* if this array is empty then entire site structure is backed up
	* public $directories = array("application", "forum", "assets/images", "assets/js", "assets/css", "system");
	*/
	private $directories = array();

	/**
	* containts a list of all the directories to ignore, leave empty to backup all
	*/
	private $ignore_directories = array('backups');

	/**
	* the directory name used for the temp file copy when everything is backed up
	*/
	private $copy_directory = "site_backup";

	/**
	* used to mark that the directory structure has alread been copied
	*/
	private $structure_copied = FALSE;

	/**
	* backup home url, i.e., http://www.example.com/backup
	* access backup home page where you can create site and database backup
	*/
	private $home_url = 'backup';

	/**
	* site backup download url, i.e., http://www.example.com/download_site_file
	* clicking on this url the site backup will be downloaded
	*/
	private $site_download_url = 'backup/download_site_file/';

	/**
	* site backup delete url, i.e., http://www.example.com/delete_site_file
	* clicking on this url the site backup will be deleted
	*/
	private $site_delete_url = 'backup/delete_site_file/';

	/**
	* db backup download url, i.e., http://www.example.com/download_db_file
	* clicking on this link the database backup will be downloaded
	*/
	private $db_download_url = 'backup/download_db_file/';

	/**
	* db backup delete url, i.e., http://www.example.com/delete_db_file
	* clicking on this url the database backup will be deleted
	*/
	private $db_delete_url = 'backup/delete_db_file/';

	/**
	* this referrer_url_key is used to store the referrer url
	* this referrer url will be used for backup operations like backup, download, delete
	* after backup operation is over then we want to redirect to referrer url
	*/
	private $back_url_key = 'referrer_url_key';
	private $back_url = 'backup';
	private $db_backup_path = 'backups/databases/';
	private $site_backup_path = 'backups/sites/';

	function __construct() {
		parent::__construct();
		$this->load->dbutil();
		$this->load->library('zip');
		$this->load->library('form_validation');
		$this->load->model('backup_model', 'backup');
		$this->back_url = $this->session->flashdata($this->back_url_key);
	}

	private function handle_error($err) {
		$this->error .= $err . "\r\n"; // "\r\n" means each error message will display in a new line
	}

	private function handle_success($succ) {
		$this->success .= $succ . "\r\n"; // "\r\n" means each error message will display in a new line
	}

	/**
	* display the main backup view page
	*/
	function index() {
		if ($this->input->post('backup')) {
			$this->form_validation->set_rules('backup_type', 'Backup Type', 'required');
			$this->form_validation->set_rules('file_type', 'File Type', 'required');
			
			if ($this->form_validation->run($this)) {
				$backup_type = $this->input->post('backup_type');
				$file_format = $this->input->post('file_type');
				
				if (trim($backup_type) == 1) {
					$this->get_db_backup($this->db_backup_path, $backup_type, $file_format);
				} else if (trim($backup_type) == 2) {
					$this->get_site_backup($this->site_backup_path, $backup_type, $file_format);
				}
			}
		}
		
		$data['errors'] = $this->error;
		$data['success'] = $this->success;
		$this->load->view('backup', $data);
	}

	/**
	*
	* db_backup
	*
	* this backs up database
	*
	* @access private
	*/
	private function get_db_backup($file_path, $backup_type, $file_format = 1) {
		$this->load->helper('string');
		$key_name1 = md5(date("d_m_Y_H_i_s")) . '_';
		$key_name2 = '_db';
		$key_name3 = date("d_m_Y_H_i_s");
		
		if ($file_format == 1) {
			//strong file name
			$file_name = $key_name1 . $key_name3 . $key_name2 . '.zip';
			$prefs = array(
				'ignore' => array($this->ignore_directories),
				'format' => 'zip', // gzip, zip, txt
				'filename' => $file_name, // File name - NEEDED ONLY WITH ZIP FILES
				'add_drop' => TRUE, // Whether to add DROP TABLE statements to backup file
				'add_insert' => TRUE, // Whether to add INSERT data to backup file
				'newline' => "\n" // Newline character used in backup
			);
			
			//Backup your entire database and assign it to a variable
			$backup = & $this->dbutil->backup($prefs);
			$file = $file_path . $file_name;
		
			if (strlen($backup)) {
				if (!write_file($file, $backup)) {
					$this->handle_error('Error while writing db backup to disk: ' . $file_name);
				} else {
					$this->handle_success('File Name: ' . $file_name . '. ');
					$this->handle_success('DB backup successfully written to disk. ');
					$date_arr = explode('_', $key_name3);
					$date = $date_arr[0] . '-' . $date_arr[1] . '-' . $date_arr[2] . ' ' . $date_arr[3] . ':' . $date_arr[4] . ':' . $date_arr[5];
					$saved_data = $this->backup->save_backup_details($file_name, $file_path);
					
					if ($saved_data !== NULL) {
						$this->handle_success('DB Backup details successfully saved to database. ');
						$this->handle_success('You can download db backup here ' . anchor($this->db_download_url . $saved_data, 'download', array('class' => 'download')));
						$this->handle_success('You can delete db backup here ' . anchor($this->db_delete_url . $saved_data, 'delete', array('class' => 'delete', 'onclick' => "return confirm('Are you sure want to delete this file ?')")));
					} else {
						if (file_exists($file)) {
							unlink($file);
						}
						$this->handle_error('Error while saving db backup to database: ' . $file_name);
					}
				}
			} else {
				$this->handle_error('Error while getting db backup: ' . $file_name);
			}
		} else if ($file_format == 2) {
			$file_name = $key_name1 . $key_name3 . $key_name2 . '.sql.gz';
			$prefs = array(
				'ignore' => array($this->ignore_directories),
				'format' => 'gzip', // gzip, zip, txt
				'filename' => $file_name, // File name - NEEDED ONLY WITH ZIP FILES
				'add_drop' => TRUE, // Whether to add DROP TABLE statements to backup file
				'add_insert' => TRUE, // Whether to add INSERT data to backup file
				'newline' => "\n" // Newline character used in backup file
			);
			//Backup your entire database and assign it to a variable
			$backup = & $this->dbutil->backup($prefs);
			$file = $file_path . $file_name;
			
			if (strlen($backup)) {
				if (!write_file($file, $backup)) {
					$this->handle_error('Error while writing db backup to disk: ' . $file_name);
				} else {
					$this->handle_success('File Name: ' . $file_name . '. ');
					$this->handle_success('DB backup successfully written to disk. ');
					$date_arr = explode('_', $key_name3);
					$date = $date_arr[0] . '-' . $date_arr[1] . '-' . $date_arr[2] . ' ' . $date_arr[3] . ':' . $date_arr[4] . ':' . $date_arr[5];
					$saved_data = $this->backup->save_backup_details($file_name, $file_path);
					
					if ($saved_data !== NULL) {
						$this->handle_success('DB Backup details successfully saved to database. ');
						$this->handle_success('You can download db backup here ' . anchor($this->db_download_url . $saved_data, 'download', array('class' => 'download')));
						$this->handle_success('You can delete db backup here ' . anchor($this->db_delete_url . $saved_data, 'delete', array('class' => 'delete', 'onclick' => "return confirm('Are you sure want to delete this file ?')")));
					} else {
						if (file_exists($file)) {
							unlink($file);
						}
						$this->handle_error('Error while saving db backup to database: ' . $file_name);
					}
				}
			} else {
				$this->handle_error('Error while getting db backup: ' . $file_name);
			}
		}
	}

	/**
	*
	* delete db file
	*
	* delete backup of database
	*
	* @access public
	*/
	function delete_db_file($file_id) {
		$this->session->keep_flashdata($this->back_url_key);
		
		if (strlen(trim($this->back_url)) <= 0 || $this->back_url == NULL) {
			$this->back_url = $this->home_url;
		}
		
		$file_data = $this->backup->delete_db_file($file_id);
		
		if ($file_data !== NULL) {
			$file = $file_data->backup_location . $file_data->backup_name;
			
			if (file_exists($file)) {
				unlink($file);
			}
		}
		
		redirect($this->back_url);
	}

	/*
	*
	* delete db file
	*
	* delete backup of the entire site
	*
	* @access public
	*/

	function download_db_file($file_id) {
		$this->session->keep_flashdata($this->back_url_key);
		
		if (strlen(trim($this->back_url)) <= 0 || $this->back_url == NULL) {
			$this->back_url = $this->home_url;
		}
		
		$file_data = $this->backup->check_db_file($file_id);
		
		if ($file_data !== NULL) {
			$this->load->helper('download');
			$file_path = $this->db_backup_path . $file_data->backup_name;
			$data = file_get_contents($file_path); // Read the file's contents
			$filename = basename($file_path);
			$ext = pathinfo($filename, PATHINFO_EXTENSION);
			$name = md5(date('d-m-Y H:i:s')) . date('_d-m-Y_H:i:s') . '.' . $ext;
			force_download($name, $data);
		}
		
		redirect($this->back_url);
	}

	/**
	*
	* delete_site_file
	*
	* delete backup of the database
	*
	* @access public
	*/
	function delete_site_file($file_id) {
		$this->session->keep_flashdata($this->back_url_key);
		
		if (strlen(trim($this->back_url)) <= 0 || $this->back_url == NULL) {
			$this->back_url = $this->home_url;
		}
		
		$file_data = $this->backup->delete_site_file($file_id);
		
		if ($file_data !== NULL) {
			$file = $file_data->backup_location . $file_data->backup_name;
			
			if (file_exists($file)) {
				unlink($file);
			}
		}
		
		redirect($this->back_url);
	}

	/*
	*
	* download_site_file
	*
	* download the file after successful backup of the entire site
	*
	* @access public
	*/

	function download_site_file($file_id) {
		$this->session->keep_flashdata($this->back_url_key);
		
		if (strlen(trim($this->back_url)) <= 0 || $this->back_url == NULL) {
			$this->back_url = $this->home_url;
		}
		
		$file_data = $this->backup->check_site_file($file_id);
		
		if ($file_data !== NULL) {
			$this->load->helper('download');
			$file_path = $file_data->backup_location . $file_data->backup_name;
			$data = file_get_contents($file_path); // Read the file's contents
			$filename = basename($file_path);
			$ext = pathinfo($filename, PATHINFO_EXTENSION);
			$name = md5(date('d-m-Y H:i:s')) . date('_d-m-Y_H:i:s') . '.' . $ext;
			force_download($name, $data);
		}
		
		redirect($this->back_url);
	}

	/**
	*
	* site_backup
	*
	* this backs up all the files located in the directories
	* specified.
	*
	* @access private
	*/
	private function get_site_backup($file_path, $backup_type, $file_format = 1) {
		$this->zip->clear_data();
		$this->check_directory($file_path);
		$this->check_directory($this->copy_directory);
		//loop each of the folder that will be backed up
		if (count($this->directories) > 0) {
			foreach ($this->directories as $dir) {
				if (!in_array($dir, $this->ignore_directories)) {
					$location = $this->base_path . $dir . "/";
					$this->zip->read_dir($location, FALSE);
				}
			}
		} else {	
			//takes a copy of the code to ensure that the backup of backups is not made.
			$copied = FALSE;
			if ($this->structure_copied === FALSE) {
				$path = str_replace('\\', '/', realpath($this->base_path));
				$copied = $this->copy_site_files($path, $this->base_path . $this->copy_directory . "/");
			}
			if (($copied === TRUE) || ($this->structure_copied === TRUE)) {
				$this->zip->read_dir($this->base_path . $this->copy_directory . "/", FALSE);
			}
		}
		flush();
		$key_name = date("d_m_Y_H_i_s");
		if ($file_format == 1) {
			$file_name = md5($key_name) . '_site.zip';
			$zipped = $this->zip->archive($file_path . $file_name);
			$this->zip->clear_data();
			
			if ($this->structure_copied === TRUE) { //we need to remove the copied files to ensure that the server is kept nice and tidy
				$this->remove_temp_files($this->base_path . $this->copy_directory . "/");
			}
			
			if ($zipped == 1) {
				$this->handle_success('File Name: ' . $file_name . '. ');
				$this->handle_success('Site backup successfully written to disk. ');
				$date_arr = explode('_', $key_name);
				$date = $date_arr[0] . '-' . $date_arr[1] . '-' . $date_arr[2] . ' ' . $date_arr[3] . ':' . $date_arr[4] . ':' . $date_arr[5];
				$file = $file_path . $file_name;
				$saved_data = $this->backup->save_backup_details($file_name, $file_path, $backup_type);
				
				if ($saved_data !== NULL) {
					$this->handle_success('Site Backup details successfully saved to database. ');
					$this->handle_success('You can get site backup here ' . anchor($this->site_download_url . $saved_data, 'download', array('class' => 'download')));
					$this->handle_success('You can delete site backup here ' . anchor($this->site_delete_url . $saved_data, 'delete', array('class' => 'delete', 'onclick' => "return confirm('Are you sure want to delete this file ?')")));
				} else {
					if (file_exists($file)) {
						unlink($file);
					}
					$this->handle_success('Error while saving site backup to database: ' . $file_name);
				}
			} else {
				$this->handle_error('Error while writing site backup to disk: ' . $file_name);
			}
		} else if ($file_format == 2) {
			$file_name = md5($key_name) . '_site.tar.gz';
			$zipped = $this->zip->archive($file_path . $file_name);
			$this->zip->clear_data();
			
			if ($this->structure_copied === TRUE) { //we need to remove the copied files to ensure that the server is kept nice and tidy
				$this->remove_temp_files($this->base_path . $this->copy_directory . "/");
			}
			
			if ($zipped == 1) {
				$this->handle_success('File Name: ' . $file_name . '. ');
				$this->handle_success('Site backup successfully written to disk. ');
				$date_arr = explode('_', $key_name);
				$date = $date_arr[0] . '-' . $date_arr[1] . '-' . $date_arr[2] . ' ' . $date_arr[3] . ':' . $date_arr[4] . ':' . $date_arr[5];
				$file = $file_path . $file_name;
				$saved_data = $this->backup->save_backup_details($file_name, $file_path, $backup_type);
				
				if ($saved_data !== NULL) {
					$this->handle_success('Site Backup details successfully saved to database. ');
					$this->handle_success('You can get site backup here ' . anchor($this->site_download_url . $saved_data, 'download', array('class' => 'download')));
					$this->handle_success('You can delete site backup here ' . anchor($this->site_delete_url . $saved_data, 'delete', array('class' => 'delete', 'onclick' => "return confirm('Are you sure want to delete this file ?')")));
				} else {
					if (file_exists($file)) {
						unlink($file);
					}
					$this->handle_success('Error while saving site backup to database: ' . $file_name);
				}
			} else {
				$this->handle_error('Error while writing site backup to disk: ' . $file_name);
			}
		}
	}

	/**
	*
	* copy_site_files
	*
	* this copies all the files located in the site
	* specified.
	*
	* @access private
	*/
	private function copy_site_files($path, $dest) {
		if (is_dir($path)) {
			@mkdir($dest);
			$objects = scandir($path);
			if (sizeof($objects) > 0) {
				foreach ($objects as $file) {
					if ($file == "." || $file == "..") {
					continue;
					}
					// go on
					if (is_dir($path . "/" . $file)) {
						if ((!in_array($file, $this->ignore_directories)) && ($file != $this->copy_directory)) {
							$this->copy_site_files($path . "/" . $file, $dest . "/" . $file);
						}
					} else {
						copy($path . "/" . $file, $dest . "/" . $file);
					}
				}
			}
			$this->structure_copied = TRUE;
			return TRUE;
		} elseif (is_file($path)) {
			$this->structure_copied = TRUE;
			return copy($path, $dest);
		} else {
			$this->structure_copied = TRUE;
			return FALSE;
		}
	}

	/*
	*
	* remove_temp_files
	*
	* this removes all the files and directories located in the directory
	*
	* WRITTEN BY: O S 18-Jun-2010 10:30 from the PHP manual rmdir comments
	*
	* WANRING: if you run this on you base_path then all the files in the site will be deleted
	*
	* @access private
	*/

	private function remove_temp_files($directory) {
		if (substr($directory, -1) == "/") {
			$directory = substr($directory, 0, -1);
		}
		if (!file_exists($directory) || !is_dir($directory)) {
			return FALSE;
		} elseif (!is_readable($directory)) {
			return FALSE;
		} else {
			$directoryHandle = opendir($directory);
			
			while ($contents = readdir($directoryHandle)) {
				if ($contents != '.' && $contents != '..') {
					$path = $directory . "/" . $contents;
					if (is_dir($path)) {
						$this->remove_temp_files($path);
					} else {
						unlink($path);
					}
				}
			}
			closedir($directoryHandle);
			if (!rmdir($directory)) {
				return FALSE;
			} else {
				return TRUE;
			}
		}
	}

	/*
	*
	* check_directory
	*
	* checks the directory to make sure it exists before we attempt to create the file
	*
	* @params string
	* @access private
	*/

	private function check_directory($path) {
		if ([email protected]($path)) {
			mkdir($path, 0755);
		} //if([email protected]($path))
		return;
	}

}

/* End of file admin.php */
/* Location: ./application/controllers/Backup.php */

Testing the Application

Now run the application. Make sure that your web server and MySQL server are running.

Home Page

Codeigniter site and database backup

Error Message

When inputs are not selected.

Codeigniter site and database backup

Backup – Get

When inputs are selected and clicked on ‘Get Backup’ button.

Codeigniter site and database backup

Backup – Save

The entry saved into the backups/databases directory.

Codeigniter site and database backup

The entry saved into the database.

Codeigniter site and database backup

Backup – Download or Delete

When you get backup you are given two options – either you can download or delete the backup.

When you click on the delete link to delete the backup you are given a confirmation link whether you really want to delete the backup.

Codeigniter site and database backup

When backup deleted from the backups/databases directory

Codeigniter site and database backup

When backup deleted from the database

Codeigniter site and database backup

Source Code

You can download source code.

Thanks for reading.

Tags:

8 thoughts on “Backup Site and Database in Codeigniter”

  5. A PHP Error was encountered
    Severity: Notice

    Message: Only variables should be assigned by reference

    Filename: controllers/backup.php

    Line Number: 151

    Backtrace:

    File: C:\xampp\htdocs\www\application\controllers\backup.php
    Line: 151
    Function: _error_handler

    File: C:\xampp\htdocs\www\application\controllers\backup.php
    Line: 115
    Function: get_db_backup

    File: C:\xampp\htdocs\www\index.php
    Line: 315
    Function: require_once


    Thank Youu

    Reply

  6. A PHP Error was encountered
    Severity: Notice

    Message: Only variables should be assigned by reference

    Filename: controllers/Backup.php

    Line Number: 154

    Backtrace:

    File: C:\xampp\htdocs\www\application\controllers\backup.php
    Line: 151
    Function: _error_handler

    File: C:\xampp\htdocs\www\application\controllers\backup.php
    Line: 115
    Function: get_db_backup

    File: C:\xampp\htdocs\www\index.php
    Line: 315
    Function: require_once

    Thank You

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *