Mar 052013
 

Sometimes, you need to restore. But you don’t know when the file changed. Here’s a simple SQL query which shows me that information:

  SELECT FN.name, P.path, J.jobid, J.starttime, pg_size_pretty( base64_decode_lstat(8, F.lstat) ) as size
    FROM filename FN, file F, job J, path P
   WHERE FN.name      = 'fruity.sql'
     AND F.filenameid = FN.filenameid
     AND F.jobid      = J.jobid
     AND F.pathid     = P.pathid
ORDER BY J.starttime desc;

And here is the output

    name    |                    path                       | jobid  |      starttime      |  size
------------+-----------------------------------------------+--------+---------------------+--------
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 123242 | 2013-03-05 08:30:32 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 123002 | 2013-03-04 10:07:43 | 172 kB
 fruity.sql | /usr/home/dan/                                | 122935 | 2013-03-04 04:03:23 | 152 kB
 fruity.sql | /usr/home/dan/                                | 123194 | 2013-03-04 04:03:23 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 122937 | 2013-03-04 01:13:55 | 172 kB
 fruity.sql | /home/dan/                                    | 123160 | 2013-03-03 07:21:31 | 171 kB
 fruity.sql | /home/dan/                                    | 122913 | 2013-03-03 07:21:31 | 171 kB
 fruity.sql | /usr/local/etc/                               | 122919 | 2013-03-03 07:16:24 | 171 kB
 fruity.sql | /usr/local/etc/                               | 123158 | 2013-03-03 07:16:24 | 171 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 122844 | 2013-03-02 07:52:51 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 122743 | 2013-03-01 07:11:35 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 122646 | 2013-02-28 07:08:40 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 122551 | 2013-02-27 07:15:07 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 122456 | 2013-02-26 07:19:54 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 122187 | 2013-02-25 07:09:59 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 122106 | 2013-02-24 09:31:26 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 122007 | 2013-02-23 07:06:49 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 121854 | 2013-02-22 07:12:28 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 121589 | 2013-02-21 07:05:44 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 121486 | 2013-02-20 07:18:51 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 121385 | 2013-02-19 07:21:14 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 121284 | 2013-02-18 07:29:33 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 121183 | 2013-02-17 08:26:45 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 120980 | 2013-02-16 07:09:29 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 120877 | 2013-02-15 08:01:38 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 120725 | 2013-02-14 07:39:30 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 120478 | 2013-02-13 07:10:08 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 120377 | 2013-02-12 07:04:18 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 120278 | 2013-02-11 07:09:33 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 120183 | 2013-02-10 07:45:39 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 120084 | 2013-02-09 07:13:03 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 119979 | 2013-02-08 07:02:34 | 172 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 119880 | 2013-02-07 07:11:34 | 172 kB
 fruity.sql | /usr/home/dan/                                | 119458 | 2013-02-04 06:22:17 | 152 kB
 fruity.sql | /usr/home/dan/                                | 119630 | 2013-02-04 06:22:17 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 119460 | 2013-02-04 02:35:34 | 172 kB
 fruity.sql | /home/dan/                                    | 119436 | 2013-02-03 07:13:50 | 171 kB
 fruity.sql | /home/dan/                                    | 119489 | 2013-02-03 07:13:50 | 171 kB
 fruity.sql | /usr/local/etc/                               | 119485 | 2013-02-03 07:10:24 | 171 kB
 fruity.sql | /usr/local/etc/                               | 119442 | 2013-02-03 07:10:24 | 171 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 118600 | 2013-01-27 09:55:28 | 172 kB
 fruity.sql | /home/dan/                                    | 118576 | 2013-01-27 06:05:25 | 171 kB
 fruity.sql | /home/dan/                                    | 118669 | 2013-01-27 06:05:25 | 171 kB
 fruity.sql | /usr/local/etc/                               | 118667 | 2013-01-27 06:01:27 | 171 kB
 fruity.sql | /usr/local/etc/                               | 118582 | 2013-01-27 06:01:27 | 171 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 118021 | 2013-01-20 08:58:34 | 172 kB
 fruity.sql | /home/dan/                                    | 118094 | 2013-01-20 06:05:00 | 171 kB
 fruity.sql | /home/dan/                                    | 117997 | 2013-01-20 06:05:00 | 171 kB
 fruity.sql | /usr/local/etc/                               | 118003 | 2013-01-20 06:04:18 | 171 kB
 fruity.sql | /usr/local/etc/                               | 118090 | 2013-01-20 06:04:18 | 171 kB
 fruity.sql | /home/dan/                                    | 121611 | 2013-01-19 06:03:28 | 171 kB
 fruity.sql | /home/dan/                                    | 117899 | 2013-01-19 06:03:28 | 171 kB
 fruity.sql | /usr/local/etc/                               | 121607 | 2013-01-19 06:02:49 | 171 kB
 fruity.sql | /usr/local/etc/                               | 117905 | 2013-01-19 06:02:49 | 171 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 117296 | 2013-01-13 08:05:43 | 171 kB
 fruity.sql | /usr/home/dan/                                | 117464 | 2013-01-07 01:08:52 | 152 kB
 fruity.sql | /usr/home/dan/                                | 116386 | 2013-01-07 01:08:52 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 116388 | 2013-01-06 22:40:52 | 171 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 115786 | 2012-12-30 11:03:12 | 171 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 115116 | 2012-12-23 13:53:39 | 171 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 114470 | 2012-12-16 07:33:43 | 169 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 113712 | 2012-12-09 07:34:08 | 167 kB
 fruity.sql | /usr/home/dan/                                | 113167 | 2012-12-02 14:13:53 | 152 kB
 fruity.sql | /usr/home/dan/                                | 113111 | 2012-12-02 14:13:53 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 113113 | 2012-12-02 11:47:18 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 112080 | 2012-11-25 06:51:19 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/database-backup/mysql/ | 111577 | 2012-11-18 06:52:59 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 110983 | 2012-11-11 06:57:21 | 166 kB
 fruity.sql | /usr/home/dan/                                | 110404 | 2012-11-04 14:51:46 | 152 kB
 fruity.sql | /usr/home/dan/                                | 110346 | 2012-11-04 14:51:46 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 110348 | 2012-11-04 13:23:30 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 110050 | 2012-10-28 07:04:18 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 109442 | 2012-10-21 06:58:33 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 108866 | 2012-10-14 06:51:14 | 166 kB
 fruity.sql | /usr/home/dan/                                | 108268 | 2012-10-08 10:33:54 | 152 kB
 fruity.sql | /usr/home/dan/                                | 108466 | 2012-10-08 10:33:54 | 152 kB
 fruity.sql | /usr/home/dan/                                | 108375 | 2012-10-07 23:44:13 | 152 kB
 fruity.sql | /usr/home/dan/                                | 108198 | 2012-10-07 23:44:13 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 108200 | 2012-10-07 16:45:05 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 107609 | 2012-09-30 06:53:09 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 107028 | 2012-09-23 06:54:25 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 106455 | 2012-09-16 06:47:56 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 105877 | 2012-09-09 06:57:14 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 105310 | 2012-09-02 12:24:30 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 104766 | 2012-08-26 06:52:38 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 104208 | 2012-08-19 06:49:35 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 103660 | 2012-08-12 06:59:40 | 166 kB
 fruity.sql | /usr/home/dan/                                | 103153 | 2012-08-05 14:40:35 | 152 kB
 fruity.sql | /usr/home/dan/                                | 103055 | 2012-08-05 14:40:35 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 103057 | 2012-08-05 13:19:38 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 102492 | 2012-07-29 07:22:52 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 101802 | 2012-07-22 06:53:10 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 101246 | 2012-07-15 06:53:08 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 100680 | 2012-07-08 06:55:51 | 166 kB
 fruity.sql | /usr/home/dan/                                | 100127 | 2012-07-01 13:42:27 | 152 kB
 fruity.sql | /usr/home/dan/                                | 100074 | 2012-07-01 13:42:27 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 | 100076 | 2012-07-01 12:23:22 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  99268 | 2012-06-21 13:33:03 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  98962 | 2012-06-17 07:30:24 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  98413 | 2012-06-10 07:41:11 | 166 kB
 fruity.sql | /usr/home/dan/                                |  97867 | 2012-06-03 12:19:46 | 152 kB
 fruity.sql | /usr/home/dan/                                |  97811 | 2012-06-03 12:19:46 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  97813 | 2012-06-03 11:06:31 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  97258 | 2012-05-27 07:04:38 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  96343 | 2012-05-20 06:51:25 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  96049 | 2012-05-13 06:50:22 | 166 kB
 fruity.sql | /usr/home/dan/                                |  95551 | 2012-05-06 14:03:48 | 152 kB
 fruity.sql | /usr/home/dan/                                |  95493 | 2012-05-06 14:03:48 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  95495 | 2012-05-06 12:56:01 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  95313 | 2012-05-03 12:44:46 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  95281 | 2012-05-03 06:01:29 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  95196 | 2012-05-02 06:01:38 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  95116 | 2012-05-01 06:01:33 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  95034 | 2012-04-30 06:01:27 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  94957 | 2012-04-29 06:02:22 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  94871 | 2012-04-28 06:01:30 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  94781 | 2012-04-27 06:01:54 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  94701 | 2012-04-26 06:00:32 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  94610 | 2012-04-25 06:01:28 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  94382 | 2012-04-22 06:08:29 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  94244 | 2012-04-21 06:08:05 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  94163 | 2012-04-20 06:08:01 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  94082 | 2012-04-19 06:08:10 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  94001 | 2012-04-18 06:08:15 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  93867 | 2012-04-17 06:08:02 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  93762 | 2012-04-16 06:07:52 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  93666 | 2012-04-15 06:26:41 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  93558 | 2012-04-14 06:07:54 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  93457 | 2012-04-13 06:07:47 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  93352 | 2012-04-12 06:07:44 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  93241 | 2012-04-11 06:08:04 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  93152 | 2012-04-10 06:07:49 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  93047 | 2012-04-09 06:07:45 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  92845 | 2012-04-07 06:07:37 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  92744 | 2012-04-06 06:07:45 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  92643 | 2012-04-05 06:07:47 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  92540 | 2012-04-04 06:08:14 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  92363 | 2012-04-03 02:28:33 | 167 kB
 fruity.sql | /usr/home/dan/                                |  92458 | 2012-04-01 12:36:56 | 152 kB
 fruity.sql | /usr/home/dan/                                |  91922 | 2012-04-01 12:36:56 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  91912 | 2012-04-01 07:34:10 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  91979 | 2012-04-01 07:34:10 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  91869 | 2012-03-31 06:00:25 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  91387 | 2012-03-26 06:00:12 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  91202 | 2012-03-24 06:00:28 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  91105 | 2012-03-23 06:00:32 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  91007 | 2012-03-22 06:00:28 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  90912 | 2012-03-21 06:00:33 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  90813 | 2012-03-20 06:00:18 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  90717 | 2012-03-19 06:00:28 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  90527 | 2012-03-17 06:00:36 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  90426 | 2012-03-16 06:00:28 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  90334 | 2012-03-15 06:00:33 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  90237 | 2012-03-14 06:00:24 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  89666 | 2012-03-08 06:00:26 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  89571 | 2012-03-07 06:00:28 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  89476 | 2012-03-06 06:00:36 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  89076 | 2012-03-03 06:00:37 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  88981 | 2012-03-02 06:13:51 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  88789 | 2012-02-29 06:00:37 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  87959 | 2012-02-20 18:38:25 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  87842 | 2012-02-19 06:20:12 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  87334 | 2012-02-14 06:00:14 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  87239 | 2012-02-13 06:00:31 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  87148 | 2012-02-12 06:18:08 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  87048 | 2012-02-11 06:00:25 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  86953 | 2012-02-10 06:00:25 | 167 kB
 fruity.sql | /usr/home/dan/                                |  86411 | 2012-02-05 14:06:42 | 152 kB
 fruity.sql | /usr/home/dan/                                |  86484 | 2012-02-05 14:06:42 | 152 kB
 fruity.sql | /usr/home/dan/                                |  86589 | 2012-02-05 14:06:42 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  86401 | 2012-02-05 07:28:58 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  86462 | 2012-02-05 07:28:58 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  85801 | 2012-01-29 06:20:11 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  85135 | 2012-01-22 06:19:52 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  84469 | 2012-01-15 06:19:46 | 167 kB
 fruity.sql | /usr/home/dan/                                |  83109 | 2012-01-01 14:52:28 | 152 kB
 fruity.sql | /usr/home/dan/                                |  83185 | 2012-01-01 14:52:28 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  83099 | 2012-01-01 07:23:40 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  83163 | 2012-01-01 07:23:40 | 167 kB
 fruity.sql | /usr/home/dan/                                |  80900 | 2011-12-04 14:43:41 | 152 kB
 fruity.sql | /usr/home/dan/                                |  80828 | 2011-12-04 14:43:41 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  80818 | 2011-12-04 07:28:57 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  80882 | 2011-12-04 07:28:57 | 167 kB
 fruity.sql | /usr/home/dan/                                |  78298 | 2011-11-06 14:48:39 | 152 kB
 fruity.sql | /usr/home/dan/                                |  78366 | 2011-11-06 14:48:39 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  78348 | 2011-11-06 07:41:09 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  78288 | 2011-11-06 07:41:09 | 167 kB
 fruity.sql | /usr/home/dan/                                |  75070 | 2011-10-02 14:27:24 | 152 kB
 fruity.sql | /usr/home/dan/                                |  75146 | 2011-10-02 14:27:24 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  75128 | 2011-10-02 07:04:48 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  75060 | 2011-10-02 07:04:48 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  74928 | 2011-09-30 06:00:25 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  74838 | 2011-09-29 06:00:12 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  74748 | 2011-09-28 06:00:15 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  74658 | 2011-09-27 06:00:18 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  74566 | 2011-09-26 06:00:32 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  74390 | 2011-09-24 06:00:23 | 167 kB
 fruity.sql | /usr/home/dan/                                |  72564 | 2011-09-04 14:28:21 | 152 kB
 fruity.sql | /usr/home/dan/                                |  72636 | 2011-09-04 14:28:21 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  72554 | 2011-09-04 07:27:58 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  72618 | 2011-09-04 07:27:58 | 167 kB
 fruity.sql | /usr/home/dan/                                |  70078 | 2011-08-07 14:31:12 | 152 kB
 fruity.sql | /usr/home/dan/                                |  70004 | 2011-08-07 14:31:12 | 152 kB
 fruity.sql | /home/dan/                                    |  70058 | 2011-08-07 08:09:11 | 152 kB
 fruity.sql | /home/dan/                                    |  69995 | 2011-08-07 08:09:11 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  70056 | 2011-08-07 07:38:53 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  69994 | 2011-08-07 07:38:53 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  68792 | 2011-07-24 06:24:09 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  68072 | 2011-07-17 06:23:51 | 167 kB
 fruity.sql | /usr/home/dan/                                |  66678 | 2011-07-03 14:39:15 | 152 kB
 fruity.sql | /usr/home/dan/                                |  66602 | 2011-07-03 14:39:15 | 152 kB
 fruity.sql | /home/dan/                                    |  66658 | 2011-07-03 08:08:22 | 152 kB
 fruity.sql | /home/dan/                                    |  66593 | 2011-07-03 08:08:22 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  66656 | 2011-07-03 07:38:18 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  66592 | 2011-07-03 07:38:18 | 167 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  65274 | 2011-06-19 06:33:40 | 166 kB
 fruity.sql | /usr/home/dan/                                |  63876 | 2011-06-05 16:12:07 | 152 kB
 fruity.sql | /usr/home/dan/                                |  63796 | 2011-06-05 16:12:07 | 152 kB
 fruity.sql | /home/dan/                                    |  63789 | 2011-06-05 11:15:42 | 152 kB
 fruity.sql | /home/dan/                                    |  63860 | 2011-06-05 11:15:42 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  63788 | 2011-06-05 10:47:12 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  63858 | 2011-06-05 10:47:12 | 166 kB
 fruity.sql | /usr/home/dan/                                |  60367 | 2011-05-02 02:45:13 | 152 kB
 fruity.sql | /usr/home/dan/                                |  60471 | 2011-05-02 02:45:13 | 152 kB
 fruity.sql | /home/dan/                                    |  60323 | 2011-05-01 09:28:41 | 152 kB
 fruity.sql | /home/dan/                                    |  60357 | 2011-05-01 09:28:41 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  60322 | 2011-05-01 09:01:39 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  60355 | 2011-05-01 09:01:39 | 166 kB
 fruity.sql | /usr/home/dan/                                |  59958 | 2011-04-26 16:00:37 | 152 kB
 fruity.sql | /usr/home/dan/                                |  59867 | 2011-04-26 16:00:37 | 152 kB
 fruity.sql | /home/dan/                                    |  59942 | 2011-04-26 10:22:30 | 152 kB
 fruity.sql | /home/dan/                                    |  59860 | 2011-04-26 10:22:30 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  59859 | 2011-04-26 09:51:54 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  59940 | 2011-04-26 09:51:54 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  59813 | 2011-04-25 06:25:58 | 166 kB
 fruity.sql | /usr/home/dan/                                |  57563 | 2011-04-03 17:17:56 | 152 kB
 fruity.sql | /usr/home/dan/                                |  57485 | 2011-04-03 17:17:56 | 152 kB
 fruity.sql | /home/dan/                                    |  57547 | 2011-04-03 11:36:14 | 152 kB
 fruity.sql | /home/dan/                                    |  57478 | 2011-04-03 11:36:14 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  57545 | 2011-04-03 11:10:03 | 165 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  57477 | 2011-04-03 11:10:03 | 165 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  56478 | 2011-03-24 06:21:47 | 165 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  56378 | 2011-03-23 06:22:19 | 165 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  56336 | 2011-03-22 06:22:38 | 165 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  56173 | 2011-03-21 06:18:56 | 165 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  55977 | 2011-03-19 06:20:38 | 165 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  55876 | 2011-03-18 06:19:16 | 165 kB
 fruity.sql | /usr/home/dan/                                |  54633 | 2011-03-06 12:57:12 | 152 kB
 fruity.sql | /usr/home/dan/                                |  54702 | 2011-03-06 12:57:12 | 152 kB
 fruity.sql | /home/dan/                                    |  54688 | 2011-03-06 08:18:43 | 152 kB
 fruity.sql | /home/dan/                                    |  54626 | 2011-03-06 08:18:43 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  54680 | 2011-03-06 07:52:56 | 165 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  54625 | 2011-03-06 07:52:56 | 165 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  53841 | 2011-02-26 06:13:18 | 166 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  53743 | 2011-02-25 06:13:42 | 166 kB
 fruity.sql | /usr/home/dan/                                |  51886 | 2011-02-06 13:55:09 | 152 kB
 fruity.sql | /usr/home/dan/                                |  51752 | 2011-02-06 13:55:09 | 152 kB
 fruity.sql | /home/dan/                                    |  51745 | 2011-02-06 08:13:15 | 152 kB
 fruity.sql | /home/dan/                                    |  51872 | 2011-02-06 08:13:15 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  51744 | 2011-02-06 07:47:43 | 164 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  51870 | 2011-02-06 07:47:43 | 164 kB
 fruity.sql | /usr/home/dan/                                |  44593 | 2011-01-02 13:23:22 | 152 kB
 fruity.sql | /usr/home/dan/                                |  51550 | 2011-01-02 13:23:22 | 152 kB
 fruity.sql | /home/dan/                                    |  51538 | 2011-01-02 08:01:28 | 152 kB
 fruity.sql | /home/dan/                                    |  44586 | 2011-01-02 08:01:28 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  44585 | 2011-01-02 07:36:14 | 165 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  51536 | 2011-01-02 07:36:14 | 165 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  44621 | 2011-01-02 07:36:14 | 165 kB
 fruity.sql | /usr/home/dan/                                |  57102 | 2010-12-05 09:36:02 | 152 kB
 fruity.sql | /usr/home/dan/                                |  40762 | 2010-12-05 09:36:02 | 152 kB
 fruity.sql | /home/dan/                                    |  40757 | 2010-12-05 07:58:14 | 152 kB
 fruity.sql | /home/dan/                                    |  57094 | 2010-12-05 07:58:14 | 152 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  51442 | 2010-12-05 07:33:14 | 165 kB
 fruity.sql | /wdc/dan/backups/ngaio/mysql/                 |  40756 | 2010-12-05 07:33:14 | 165 kB
(274 rows)
bacula=#

Based on that output, I want to look at restoring from Jan 13 and before. That’s when the filesize change last changed from 172KB.

Website Pin Facebook Twitter Myspace Friendfeed Technorati del.icio.us Digg Google StumbleUpon Premium Responsive