Restoring database from backup

[allenerenee]

I used Timeshift to make a backup of all my files in the middle of January, just before upgrading from Mint 18.3 to Mint 19.3. It made a backup of my recipe database with the extension .db.backup In the middle of February, my hard drive died. Poking around a little, I am not able to simply open the file with Gourmet 0.17 or the Python3 version, nor does following the instructions found at https://linuxhint.com/backup-restore-sqlite/ (my new system tells me the file is an SQlite database) How can I restore my (sizable) recipe collection from the .db.backup file?

Expected Behavior

Gourmet should recognize and be able to restore backups made from system utilities such as timeshift.

Current Behavior

Currently, attempting to restore the file produce no results.

Environment

• Operating System:
• Version or commit id:
• Installed as Flatpak or Python package?: Database made in Python package in Linux Mint 18.3 via Timeshift. Attempting to restore in MX Linux KDE 19, from the flatpak editions. System data: [code] System: Host: Kernel: 5.10.0-5mx-amd64 x86_64 bits: 64 compiler: N/A parameters: ro root=UUID= initrd=boot\initrd.img-5.10.0-5mx-amd64 Desktop: KDE Plasma 5.14.5 wm: kwin_x11 dm: SDDM Distro: MX-19.4_kde_x64 patito feo March 31 2021 base: Debian GNU/Linux 10 (buster) Machine: Type: Laptop System: LENOVO product: 20U3CTO1WW v: ThinkPad L15 Gen 1 serial: Chassis: type: 10 serial: Mobo: LENOVO model: 20U3CTO1WW v: SDK0J40709 WIN serial: UEFI: LENOVO v: R17ET25W (1.08 ) date: 12/08/2020 Battery: ID-1: BAT0 charge: 26.8 Wh condition: 46.9/45.7 Wh (103%) volts: 11.3/11.1 model: Celxpert 5B10W13897 type: Li-poly serial: status: Discharging cycles: 1 CPU: Topology: Dual Core model: Intel Core i3-10110U bits: 64 type: MT MCP arch: Kaby Lake family: 6 model-id: 8E (142) stepping: C (12) microcode: DE L2 cache: 4096 KiB flags: avx avx2 lm nx pae sse sse2 sse3 sse4_1 sse4_2 ssse3 vmx bogomips: 20799 Speed: 800 MHz min/max: 400/4100 MHz Core speeds (MHz): 1: 800 2: 800 3: 800 4: 800 Vulnerabilities: Type: itlb_multihit status: KVM: VMX disabled Type: l1tf status: Not affected Type: mds status: Not affected Type: meltdown status: Not affected Type: spec_store_bypass mitigation: Speculative Store Bypass disabled via prctl and seccomp Type: spectre_v1 mitigation: usercopy/swapgs barriers and __user pointer sanitization Type: spectre_v2 mitigation: Enhanced IBRS, IBPB: conditional, RSB filling Type: srbds mitigation: TSX disabled Type: tsx_async_abort status: Not affected Graphics: Device-1: Intel CometLake-U GT2 [UHD Graphics] vendor: Lenovo driver: i915 v: kernel bus ID: 00:02.0 chip ID: 8086:9b41 Display: x11 server: X.Org 1.20.10 driver: modesetting unloaded: fbdev,vesa compositor: kwin_x11 resolution: 1366x768~60Hz OpenGL: renderer: Mesa Intel UHD Graphics (CML GT2) v: 4.6 Mesa 20.3.4 direct render: Yes Audio: Device-1: Intel Comet Lake PCH-LP cAVS vendor: Lenovo driver: snd_hda_intel v: kernel bus ID: 00:1f.3 chip ID: 8086:02c8 Sound Server: ALSA v: k5.10.0-5mx-amd64 Network: Device-1: Intel Ethernet I219-V vendor: Lenovo driver: e1000e v: kernel port: efa0 bus ID: 00:1f.6 chip ID: 8086:0d4f IF: eth0 state: down mac: Device-2: Intel Wi-Fi 6 AX200 driver: iwlwifi v: kernel port: efa0 bus ID: 04:00.0 chip ID: 8086:2723 IF: wlan0 state: up mac: Drives: Local Storage: total: 931.51 GiB used: 107.51 GiB (11.5%) ID-1: /dev/sda vendor: Western Digital model: WD10SPSX-08A6W size: 931.51 GiB block size: physical: 4096 B logical: 512 B speed: 6.0 Gb/s rotation: 7200 rpm serial: rev: 1A01 scheme: GPT Partition: ID-1: / raw size: 48.83 GiB size: 47.81 GiB (97.92%) used: 10.94 GiB (22.9%) fs: ext4 dev: /dev/sda6 ID-2: /home raw size: 642.58 GiB size: 631.49 GiB (98.27%) used: 96.58 GiB (15.3%) fs: ext4 dev: /dev/sda8 ID-3: swap-1 size: 9.77 GiB used: 0 KiB (0.0%) fs: swap swappiness: 15 (default 60) cache pressure: 100 (default) dev: /dev/sda7 Sensors: System Temperatures: cpu: 39.0 C mobo: N/A Fan Speeds (RPM): cpu: 0 Repos: No active apt repos in: /etc/apt/sources.list Active apt repos in: /etc/apt/sources.list.d/brave-browser-release.list 1: deb [arch=amd64] https://brave-browser-apt-release.s3.brave.com/ buster main Active apt repos in: /etc/apt/sources.list.d/debian-stable-updates.list 1: deb http://deb.debian.org/debian buster-updates main contrib non-free Active apt repos in: /etc/apt/sources.list.d/debian.list 1: deb http://deb.debian.org/debian buster main contrib non-free 2: deb http://deb.debian.org/debian-security buster/updates main contrib non-free Active apt repos in: /etc/apt/sources.list.d/mx.list 1: deb http://mirrors.rit.edu/mxlinux/mx-packages/mx/repo/ buster main non-free 2: deb http://mirrors.rit.edu/mxlinux/mx-packages/mx/repo/ buster ahs Active apt repos in: /etc/apt/sources.list.d/skype-stable.list 1: deb [arch=amd64] https://repo.skype.com/deb stable main No active apt repos in: /etc/apt/sources.list.d/various.list Info: Processes: 250 Uptime: 9h 56m Memory: 7.44 GiB used: 2.87 GiB (38.6%) Init: SysVinit v: 2.93 runlevel: 5 default: 5 Compilers: gcc: 8.3.0 alt: 8 Shell: quick-system-in running in: quick-system-in inxi: 3.0.36 [/code]

[thinkle]

The file should be a SQLite file so if you can't access it with a generic SQLite tool, I'd be worried the file might be corrupt.

[allenerenee]

I can access it with an SQLite database viewer, so that's not the issue. All the data seems to be fine. I just haven't the foggiest how to get it back into Gourmet, since the DB browser can only export as sql, csv, or json.

[cydanil]

Hi,
You should be able to open the database by running Goumet as follows, from a terminal:

gourmet --database-url sqlite:////home/cydanil/Documents/recipes.db.backup

Note the four leading ////

If these are loaded correctly, you may look at moving the backed up database to the Gourmet directory:

cp recipes.db.backup ~/.gourmet/recipes.db