Parent Directory | Revision Log
generate increment filenames for DVD
1 | -- display all files (increments) on one DVD |
2 | select |
3 | hosts.name || '_' || |
4 | shares.name || '_' || |
5 | backups.num as increment_name, |
6 | backups.date::abstime, |
7 | backups.type, |
8 | backups.size, |
9 | backups.parts, |
10 | backups.inc_size, |
11 | backups.inc_deleted |
12 | from archive_backup |
13 | join archive on archive_id = archive.id |
14 | join backups on backup_id = backups.id |
15 | join shares on shareid = shares.id |
16 | join hosts on backups.hostid = hosts.id |
17 | where dvd_nr = 14 |
18 | order by inc_size desc |
19 | ; |
ViewVC Help | |
Powered by ViewVC 1.1.26 |