CodeIgniter Forums

Full Version: how to optimize backup database with CI
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

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 ?