• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Export DB to sql file

#1
[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.

#2
[eluser]eoinmcg[/eluser]
take a look at the CI database utilities class:
http://ellislab.com/codeigniter/user-gui...ities.html

it also provides backup functionality and some other handy tools too.


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.