• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
how to optimize backup database with CI


When you backup a large database with CI, the producted file contains a lot of request "INSERT INTO TABLE VALUES (...)".

Example : a table with 10000 lines.
The export produces 10000 INSERT INTO only for this table. Imagine when you have a lot of tables.
I want to perform that with only one "INSERT INTO" by table, like phpmyadmin does for example.
It's very useful when you need to restore database in order to avoid max execution time exceeded. You have only one request by table and your system is always performing.

If somebody know how to do please ?

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

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