Where can I retrieve my subscription-URL's from the database?

[davralin]

Greetings,
I managed to destroy my previous nextcloud-install, and my backup's were not up to par.

Therefore, I was stuck with a database-dump, and a dump of all the files in $datadir - thinking that would be enough.

After a slow and awful recovery, I'm now in a position where I need to recover my news-subscriptions - my thought was to load up the database-dump in a disposable database, and look at the data with phpmyadmin, and just extract and sub each manually.

In my current/new install I have News running, but when I point phpmyadmin to it, I can't see any obvious places where I can extract the data - where should I look to find the relevant parts I need, or is this effort a waste of my time?

[SMillerDev]

There are *prefix*_news_folders, *prefix*_news_feeds and *prefix*_news_items tables that contain your old data.

[davralin]

Found the relevant stuff in oc_news_feeds - for anyone else wondering grep oc_news_feeds nextcloud.sql | sed 's/,/\n/g' | grep http was fairly helpful.

Thanks a bunch! :-)