Arch Linux

estov

Member

Registered: 2015-05-22

Posts: 10

[solved] Browse databases like core.db

Hi,

for learning purposes i wanna look into the pacman databases like /var/lib/pacman/sync/core.db
But when I open it with sql browser it says

 /**** ERROR: (26) file is encrypted or is not a database *****

How can i watch the contents of this file?

Thanks in advance!

Last edited by estov (2015-10-29 11:40:27)

WorMzy

Forum Moderator

From: Scotland

Registered: 2010-06-16

Posts: 11,855

Website

Re: [solved] Browse databases like core.db

The databases are just gzipped tarballs containing a number of text files, there's no SQL involved.

Just use tar or bsdtar to list/extract the contents.

e.g.

tar tf /var/lib/pacman/sync/core.db

---

Sakura:-
Mobo: MSI MAG X570S TORPEDO MAX // Processor: AMD Ryzen 9 5950X @4.9GHz // GFX: AMD Radeon RX 5700 XT // RAM: 32GB (4x 8GB) Corsair DDR4 (@ 3000MHz) // Storage: 1x 3TB HDD, 6x 1TB SSD, 2x 120GB SSD, 1x 275GB M2 SSD

Making lemonade from lemons since 2015.

estov

Member

Registered: 2015-05-22

Posts: 10

Re: [solved] Browse databases like core.db

Thanks!

karol

Archivist

Registered: 2009-05-06

Posts: 25,440

Re: [solved] Browse databases like core.db

$ file /var/lib/pacman/sync/core.db
/var/lib/pacman/sync/core.db: gzip compressed data, last modified: Thu Oct 29 13:12:11 2015, from Unix

When you decompress it, 'file' should show it's a 'POSIX tar archive'.