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.
