CodeIgniter Forums
Robust database backup solution needed - for large databases - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forum-21.html)
+--- Thread: Robust database backup solution needed - for large databases (/thread-33152.html)



Robust database backup solution needed - for large databases - El Forum - 08-17-2010

[eluser]skattabrain[/eluser]
I would love to use CI's database backup functions, but they exhaust memory too quickly. I have a fairly large database and it chokes every time.

Backing this up daily is becoming a very serious and necessary duty as the business depends on this application to run. Now, it needs to be done daily, so I'm planning on creating a 2 step plan on a cron job ... first to create the backup file, then the script will use CI to ftp it somewhere.

Has anyone come up with a phpMyAdmin style database backup? Wondering if there is something out there that people have used with CI.

Integration with CI is kind of a necessity.

Thanks for any ideas/opinions.


Robust database backup solution needed - for large databases - El Forum - 08-17-2010

[eluser]n0xie[/eluser]
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html