Welcome Guest, Not a member yet? Register   Sign In
how to optimize backup database with CI
#1

(This post was last modified: 03-24-2016, 01:44 AM by casa.)

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 ?
Reply




Theme © iAndrew 2016 - Forum software by © MyBB