Robust database backup solution needed - for large databases |
[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.
[eluser]n0xie[/eluser]
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html |
Welcome Guest, Not a member yet? Register Sign In |