*restore First you select one or more JobIds that contain files to be restored. You will be presented several methods of specifying the JobIds. Then you will be allowed to select which files from those JobIds are to be restored. To select the JobIds, you have the following choices: 1: List last 20 Jobs run 2: List Jobs where a given File is saved 3: Enter list of comma separated JobIds to select 4: Enter SQL list command 5: Select the most recent backup for a client 6: Select backup for a client before a specified time 7: Enter a list of files to restore 8: Enter a list of files to restore before a specified time 9: Find the JobIds of the most recent backup for a client 10: Find the JobIds for a backup for a client before a specified time 11: Enter a list of directories to restore for found JobIds 12: Select full restore to a specified Job date 13: Cancel Select item: (1-13): 6 The restored files will the most current backup BEFORE the date you specify below. Enter date as YYYY-MM-DD HH:MM:SS :2021-12-27 22:00:00 Defined Clients: 1: bareos-fd 2: vm-aiqi-linux-test-backup-fd 3: vm-aiqiit-web-fd 4: vm-aiqiit-windows-test-backup-fd Select the Client (1-4): 2 The defined FileSet resources are: 1: LinuxAll-vm-aiqi-linux-test-backup 2: MARIABACKUP-vm-aiqi-linux-test-backup Select FileSet resource (1-2): 1 +-------+-------+----------+----------------+---------------------+------------------------------------------------+ | jobid | level | jobfiles | jobbytes | starttime | volumename | +-------+-------+----------+----------------+---------------------+------------------------------------------------+ | 24 | F | 108,199 | 13,145,763,765 | 2021-12-25 08:06:41 | AI-Consolidated-vm-aiqi-linux-test-backup-0006 | | 27 | I | 95 | 68,530 | 2021-12-25 20:00:04 | AI-Incremental-vm-aiqi-linux-test-backup0008 | | 32 | I | 40 | 1,322,314 | 2021-12-26 20:00:09 | AI-Incremental-vm-aiqi-linux-test-backup0012 | | 37 | I | 53 | 1,429,611 | 2021-12-27 20:00:12 | AI-Incremental-vm-aiqi-linux-test-backup0015 | | 41 | I | 140 | 941,981 | 2021-12-27 21:35:21 | AI-Incremental-vm-aiqi-linux-test-backup0015 | +-------+-------+----------+----------------+---------------------+------------------------------------------------+ You have selected the following JobIds: 24,27,32,37,41 Building directory tree for JobId(s) 24,27,32,37,41 ... ++++++++++++++++++++++++++++++++++++++++++++ 96,918 files inserted into the tree. You are now entering file selection mode where you add (mark) and remove (unmark) files to be restored. No files are initially added, unless you used the "all" keyword on the command line. Enter "done" to leave this mode. cwd is: / $ cd /var/lib/mysql.dumps/wordpressdb/ cwd is: /var/lib/mysql.dumps/wordpressdb/ $ dir -rw-r--r-- 1 0 (root) 112 (bareos) 1830 2021-12-27 21:35:21 /var/lib/mysql.dumps/wordpressdb/%create.gz -rw-r--r-- 1 0 (root) 112 (bareos) 149 2021-12-25 07:55:02 /var/lib/mysql.dumps/wordpressdb/%tables -rw-r--r-- 1 0 (root) 112 (bareos) 783 2021-12-25 07:55:02 /var/lib/mysql.dumps/wordpressdb/wp_commentmeta.sql.gz -rw-r--r-- 1 0 (root) 112 (bareos) 1161 2021-12-25 07:55:02 /var/lib/mysql.dumps/wordpressdb/wp_comments.sql.gz -rw-r--r-- 1 0 (root) 112 (bareos) 869 2021-12-25 07:55:02 /var/lib/mysql.dumps/wordpressdb/wp_links.sql.gz -rw-r--r-- 1 0 (root) 112 (bareos) 236139 2021-12-27 21:35:21 /var/lib/mysql.dumps/wordpressdb/wp_options.sql.gz -rw-r--r-- 1 0 (root) 112 (bareos) 1650 2021-12-27 21:35:21 /var/lib/mysql.dumps/wordpressdb/wp_postmeta.sql.gz -rw-r--r-- 1 0 (root) 112 (bareos) 3951 2021-12-27 21:35:21 /var/lib/mysql.dumps/wordpressdb/wp_posts.sql.gz -rw-r--r-- 1 0 (root) 112 (bareos) 770 2021-12-25 07:55:02 /var/lib/mysql.dumps/wordpressdb/wp_term_relationships.sql.gz -rw-r--r-- 1 0 (root) 112 (bareos) 838 2021-12-25 07:55:02 /var/lib/mysql.dumps/wordpressdb/wp_term_taxonomy.sql.gz -rw-r--r-- 1 0 (root) 112 (bareos) 780 2021-12-25 07:55:02 /var/lib/mysql.dumps/wordpressdb/wp_termmeta.sql.gz -rw-r--r-- 1 0 (root) 112 (bareos) 814 2021-12-25 07:55:02 /var/lib/mysql.dumps/wordpressdb/wp_terms.sql.gz -rw-r--r-- 1 0 (root) 112 (bareos) 1405 2021-12-27 21:35:21 /var/lib/mysql.dumps/wordpressdb/wp_usermeta.sql.gz -rw-r--r-- 1 0 (root) 112 (bareos) 983 2021-12-25 07:55:02 /var/lib/mysql.dumps/wordpressdb/wp_users.sql.gz mark /var/lib/mysql.dumps/wordpressdb/%create.gz /var/lib/mysql.dumps/wordpressdb/%tables /var/lib/mysql.dumps/wordpressdb/wp_commentmeta.sql.gz /var/lib/mysql.dumps/wordpressdb/wp_comments.sql.gz /var/lib/mysql.dumps/wordpressdb/wp_links.sql.gz /var/lib/mysql.dumps/wordpressdb/wp_options.sql.gz /var/lib/mysql.dumps/wordpressdb/wp_postmeta.sql.gz /var/lib/mysql.dumps/wordpressdb/wp_posts.sql.gz /var/lib/mysql.dumps/wordpressdb/wp_term_relationships.sql.gz /var/lib/mysql.dumps/wordpressdb/wp_term_taxonomy.sql.gz /var/lib/mysql.dumps/wordpressdb/wp_termmeta.sql.gz /var/lib/mysql.dumps/wordpressdb/wp_terms.sql.gz /var/lib/mysql.dumps/wordpressdb/wp_usermeta.sql.gz /var/lib/mysql.dumps/wordpressdb/wp_users.sql.gz 14 files marked. $ done Bootstrap records written to /var/lib/bareos/bareos-dir.restore.4.bsr The job will require the following Volume(s) Storage(s) SD Device(s) =========================================================================== AI-Consolidated-vm-aiqi-linux-test-backup-0006 FileStorage-AI-Consolidated FileStorage-AI-Consolidated AI-Incremental-vm-aiqi-linux-test-backup0015 FileStorage-AI-Incremental FileStorage-AI-Incremental Volumes marked with "*" are online. 14 files selected to be restored. Run Restore job JobName: RestoreFiles Bootstrap: /var/lib/bareos/bareos-dir.restore.4.bsr Where: /tmp/bareos-restores Replace: Always FileSet: LinuxAll Backup Client: vm-aiqi-linux-test-backup-fd Restore Client: vm-aiqi-linux-test-backup-fd Format: Native Storage: FileStorage-AI-Consolidated When: 2021-12-27 22:49:35 Catalog: MyCatalog Priority: 10 Plugin Options: *None* OK to run? (yes/mod/no): yes Job queued. JobId=45 You have messages. * Messages: 12 2021-12-27 22:49:43 bareos-sd JobId 45: Please mount read Volume "AI-Incremental-vm-aiqi-linux-test-backup0015" for: Job: RestoreFiles.2021-12-27_22.49.39_00 Storage: "FileStorage-AI-Consolidated" (/var/lib/bareos/storage-AI-Consolidated) Pool: Incremental-BareOS Media type: File 11 2021-12-27 22:49:43 bareos-sd JobId 45: Warning: stored/acquire.cc:286 Read open device "FileStorage-AI-Consolidated" (/var/lib/bareos/storage-AI-Consolidated) Volume "AI-Incremental-vm-aiqi-linux-test-backup0015" failed: ERR=stored/dev.cc:716 Could not open: /var/lib/bareos/storage-AI-Consolidated/AI-Incremental-vm-aiqi-linux-test-backup0015, ERR=No such file or directory