Member:
Markus ⋅
Date: May 17, 2010, 08:39 PM
⋅ Subject: "Re: What to backup in iWiccle."
Hi John!
Yes that's quite sufficient for restoring everything in the event of an unrecoverable server failure.
I notice however that there are a few new tables that aren't included in the backup. I have fixed this in my files for the next release. If you want to do this ahead of others, open up /core/admin/admin_area_system.php, and scroll to function system_backups() at line 48. In there, change the $tables array in the following:
$context = "all";
$tables = array("categories", "choices", "columns", "comments", "favorites", "fields", "field_data", "layouts", "mail", "masks", "members", "modules", "options", "parents", "posts", "skins", "tags", "threads", "units", "uploads", "usergroups", "widgets");
To read:
$tables = array("categories", "choices", "columns", "comments", "error_log", "favorites", "fields", "field_data", "forms", "layouts", "mail", "masks", "members", "modules", "options", "page_history", "parents", "posts", "profiles", "skins", "tags", "threads", "units", "uploads", "usergroups", "widgets");
And this will take a complete backup of all 26 tables in the database.
If you're interested in what the other two options do:
- "Backup Content" backs up tables "categories", "comments", "parents", "posts", "tags", "threads", "uploads".
- "Backup Users" backs up tables "favorites", "fields", "field_data", "masks", "members", "usergroups".
If you ever need to extend these or create new backup configurations, simply add tables to the list, or create a new entry in the file as case "my_backup", and make a link to index.php?module=admin&show=system&area=backups&backup=my_backup. It's hooked up with a generic MySQL table exporter, so you could even use it (together with Queries::export_table()) to backup other databases.
The backup system will be extended in a future release to include easy import/restore options, and there's a whole lot more in works to expand your control over data import and export, and the database in general.