<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
session_start(); //we need to call PHP's session object to access it through CI
class dbBackup extends CI_Controller {
	function __construct() {
		parent::__construct();
		$this->load->dbutil();
		$this->load->helper('file');
		$this->load->helper('download');
	}
  function index($offset = 0) {
  	echo date('Ymd');
  }
  function download($offset = '') {
  	if ($offset == date('Ymd')) {
  		// Backup your entire database and assign it to a variable
		$backup = $this->dbutil->backup();
		$dbName = $this->db->database;
		$fileName = $dbName.'_'.date('Ymd').'.gz';
		write_file(base_url().'apm/dbBackup/'.$fileName, $backup);
		force_download($fileName, $backup);
  	}
  }
}