Mark Nienberg wrote:
I'm using Bacula to back up a Linux Samba fileserver among other
machines. Of course the clients to the fileserver are windows machines
and they don't care about case in filenames. They create all sorts of
case combinations like "document1.doc", "Document2.DOC" and so on.
My most common restore scenario is when someone deletes or corrupts a
file and asks me to restore a previous version of it. The easiest way
to do this in the console is (I think) to use the query command option 2
"List Jobs where a given File is saved", and then pick an appropriate
jobID to restore from based on date of backup.
The problem is that the search for the filename is case sensitive (the
MySQL field is type "binary") so it is hard to guess what filename to
enter. I wonder if I could use option 4 "Enter SQL list command" to do
a case-insensitive search. Any suggestions on what this SQL command
would look like for MySQL? Or is there a better way to do this?
One method:
Do you locate(1) on the Linux boxes? If you don't have it enabled set it
to run at least as frequently as you Backup. Then you can use
locate+grep to find your files.
Example:
locate /raid/samba/home/dom | grep -i ".doc"
This will list off all the files locate last saw and you can grep on
that list in any way you like (eg: case insenstive).
Just make sure you archive your old locate databases rather than
overwriting and you should have the ability to go back in time and
search in a variety of ways over your SAMBA server.
A little scripting required perhaps but a work-able solution.
Cheers,
Dominic
Thanks,
Mark
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live
webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
