Home » CodeIgniter » Export Database using codeigniter

Export Database using codeigniter

Database Utility Class : CodeIgniter
PHP script to download mysql db-codeigniter,Backup MySQL database with CodeIgniter
public function dbexport() {
$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 = 'public/uploads/'.$db_name;
$this->load->helper('file');
write_file($save, $backup);
$this->load->helper('download');
force_download($db_name, $backup);
}

Leave a Reply

x

Check Also

Send SMS using CodeIgniter

$url = 'http://smsgateways.com/api/sendmsg.php?' . http_build_query([ 'user' => '', 'pass' => '', 'sender' => '', 'phone' ...