CodeIgniter Forums
Export DB to sql file - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: Export DB to sql file (/thread-41742.html)



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.