+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: how to optimize backup database with CI (/showthread.php?tid=64770)
how to optimize backup database with CI - casa - 03-24-2016
Hello,
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 ?