[eluser]gulan[/eluser]
It works...Thanks...
I have one more query... I want to take the backup of second DB .
so I created a file controller/backup.php with the following code.
$DB1 = $this->load->database('default', TRUE);
$DB2 = $this->load->database('second', TRUE);
$this->load->dbutil();
$backup =& $this->dbutil->backup();
$this->load->helper('file');
write_file('../../../Desktop/mybackup.gz', $backup);
but Im getting the backup of the first database ("default")
in codeigniter documentation I found that we have to change all
$this->db->
to
$DB1->
But here is the only place I want to connect and manipulate DB2 so is there any better and simple way to handle it without changing all $this->db-> ????
Thanks
gulan