Backup Strategy -- Need Advice
What is the backup strategy employed by large Tikis (such as tw.o)? I have a CRON job that does a weekly SQL dump, but files are averaging more than 8MB (gzipped).
I tried to perform a test recovery, and MySQL timed out. I've increased the execution limit in the PHP.INI file, but still no go.
How are other Tiki Admins handling backup/recovery? Is there a way, when dumping my database, to make multiple files of smaller size?
Tx,
-Rick