Has anyone had to do restore from nothing but files and a SQL backup?
If so, what are the steps?
For example, what information is in the SQL databases versus what
information is stored in files on the hard disc? Are all profiles,
filters, etc. stored in the SQL database?
Dave
There are basically four things that you'll want to look into backing
up:
1. Configuration data - This is stored in the MySQL/PostgreSQL
database. Creating a dump of this database will effectively back it
up.
2. Report data - This is a proprietary database that's stored in the
data directory from your Urchin installation directory. You should
back up this entire directory.
3. Report customizations - These are stored in the lib/custom folder.
If you've made any customizations such as custom reports/data maps,
you should back up this entire directory.
4. Custom configuration settings - If you've made any changes to the
following files, you'll want to back them up as well:
etc/session.conf
etc/urchin.conf
var/urchinwebd.conf
It may be a good idea just to back these up anyway.
There's a good article on the process of moving Urchin from one server
to another here:
http://www.urchintools.com/urchin6/advanced-techniques/how-to-move-or...
They also have Backup/Restore utility that's part of their "Toolbelt
for Urchin Framework":
http://www.urchintools.com/toolbelt/config-backup-restore
I'm not sure what cost is associated with the Urchin Toolbelt, but
there is a free trial you can try.
Jeremy Aube
http://www.roirevolution.com/urchin