This is meant to be a backup utility for big forums that have big DB backup files, but still want to keep it safe or even very safe.
Maybe some cron-like (or just cron) utility will be given to backup daily or hourly things that change frequently - like posts, topics and PMs.
I will think of integrating some existing MODs, but I want to keep it working for all users that can use the DB backup already. To give the ability to be DB unrelaint I'm thinking of integrating this somehow with EasyMOD (or to be more exact with SQL parser) so it can retrieve any important table changes.
Users (admin only of course) should also have the possibility to add tables that they want to backup by default and those to backup daily and to backup partially (a field name containing the date in PHP format should be given here).
First version (planned) features:
- choose to backup from date posts, PMs, topics
(last edited time should be taken into account)
(problem: admin/mod edits to posts do not evaluate last edit?)
- choose to omit search and session tables (as in lightbackup)
(not really important tables: 'search_results', 'search_wordlist', 'search_wordmatch', 'sessions' )
- add the date to file name in nicely sortable order like: db_backup_2006_01_31.sql
(this format should be changeable in the future)
I want to change as less as possible so (as written above) it will work for any databases that it works now.
If there will be a feature to save the generated file on server, then it will add some random (+ md5) codes to the file name. This way you can load through FTP at any time without fear of it being downloaded by someone else.
And now... Give me some feature requests .