+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Export DB to sql file (/showthread.php?tid=41742)
Export DB to sql file - El Forum - 05-16-2011
[eluser]Unknown[/eluser]
This is a library class to export structure as well as data from tables also export complete db in sql file.
The implementation is very simple. Example implementation is below:
Code:
// Load Export sql library
$this->load->library('export_sql');
// Add where clause
$where = array(
'id' => 123,
);
// Create list of tables to be exported.
// Mark whether to dump data as true/false
// By default its false.
$tables = array(
'table1' => TRUE,
'table2' => TRUE,
);
$this->export_sql->export($tables, $where, FALSE); // If true is provided for the last argument, it will export full DB.Place the attached library file in you application libraries directory
./application/libraries/
Feel free to let me know your comments.
Export DB to sql file - El Forum - 05-16-2011
[eluser]eoinmcg[/eluser]
take a look at the CI database utilities class:
http://ellislab.com/codeigniter/user-guide/database/utilities.html
it also provides backup functionality and some other handy tools too.