MySQL Backup Script in CI

[eluser]jedd[/eluser]
[quote author="deanpcmad" date="1237245091"]"take the DB offline and do a dump (preferred - much faster)."
How would I do that? Is there a guide on how to?[/quote]

Depends on your system.

On mine (a real OS) I run this kind of script from cron:

Code:

/etc/init.d/mysql stop
tar cfz /var/local/backups/mysql-$date.tgz  /var/lib/mysql
/etc/init.d/mysql start

I have a snippet somewhere to give me $date in a format I like (ISO8601).

If you can't take your DB offline for backing up then there are other MySQL utilities for pulling data out of a live system, but if you've got that kind of requirement you probably wouldn't be asking how to do such a thing on a CI forum.

Oh .. and you really do not want to do backups, via cron, written in PHP, of your database. Trust me.