Backup MySQL database with CodeIgniter

February 25, 2021
30
Views

Use the following code to create the .zip file of your database and download.

$this->load->dbutil();

$prefs = array(     
    'format'      => 'zip',             
    'filename'    => 'my_db_backup.sql'
    );
$backup =& $this->dbutil->backup($prefs); 

$db_name = 'backup-on-'. date("Y-m-d-H-i-s") .'.zip';

$save = 'pathtobkfolder/'.$db_name;

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

write_file($save, $backup); 


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

force_download($db_name, $backup);

Article Tags:
· ·
Article Categories:
Codeigniter · Php

Comments are closed.