Welcome Guest, Not a member yet? Register   Sign In
backup database problem
#5

(01-18-2018, 10:05 AM)InsiteFX Wrote:
PHP Code:
$prefs = array(
 
       'tables'        => array('table1''table2'),   // Array of tables to backup.
 
       'ignore'        => array(),                     // List of tables to omit from the backup
 
       'format'        => 'txt'                      // gzip, zip, txt
 
       'filename'      => 'mybackup.sql'             // 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
);

$this->dbutil->backup($prefs); 

Look at the filename and format parameters.

hi tanks, now work , this is my controller :

Code:
public function backup_database(){

       $data=[];

       $oggi=date ("d-m-Y");

       $this->load->dbutil();

       $prefs = array(    
               'format'      => 'zip',            
               'filename'    => 'my_db_backup.sql'
             );


       $backup =& $this->dbutil->backup($prefs);

       $db_name = 'backup-on-'. $oggi .'.zip';
       $save = 'backup_db/'.$db_name;

       $this->load->helper('file');
     

       if( write_file($save, $backup)){

           $this->load->helper('download');
           force_download($db_name, $backup);

           $this->load->view('templates/header_admin');
           $this->load->view('templates/menu_admin');
           $this->load->view('admin/db_backup_ok', $data);
           $this->load->view('templates/footer_admin');


       }else{
          $this->load->view('templates/header_admin');
           $this->load->view('templates/menu_admin');
           $this->load->view('admin/db_backup_error', $data);
           $this->load->view('templates/footer_admin');

       }




   }
Reply


Messages In This Thread
backup database problem - by pippuccio76 - 01-17-2018, 02:47 PM
RE: backup database problem - by InsiteFX - 01-18-2018, 04:47 AM
RE: backup database problem - by pippuccio76 - 01-18-2018, 05:14 AM
RE: backup database problem - by InsiteFX - 01-18-2018, 10:05 AM
RE: backup database problem - by pippuccio76 - 01-18-2018, 11:12 AM



Theme © iAndrew 2016 - Forum software by © MyBB