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);
}
my normal database size is 32 mb but with this method my database downloaded 97mb and showing error when uploading form localhost/phpmyadmin
This helped me a lot..
thank you.
you are welcome