Deleting entries from gbpvr.db3 with SQLite (or Flushing entirely)

[jksmurf]

I seem to have a lot of dormant entries in my gbpvr.db3 when I look at SQLite, and most of them seem to be from channels that I no longer watch (Unchecked channels in the Config).

Is there some way of flushing the database so that only entries which are valid for current channels, as well as existing recodded shows, are retained?

There are about 3133 entries in the db3 database, which seems a lot for 4 channels, 1~2 weeks epg max. Some I know are not assocaited with those channels.
k.

[dennit]

I seem to have a lot of dormant entries in my gbpvr.db3 when I look at SQLite, and most of them seem to be from channels that I no longer watch (Unchecked channels in the Config).

Is there some way of flushing the database so that only entries which are valid for current channels, as well as existing recodded shows, are retained?

There are about 3133 entries in the db3 database, which seems a lot for 4 channels, 1~2 weeks epg max. Some I know are not assocaited with those channels.
k.

Yes. In SQLiteSpy try Execute|Vacuum Database.

Of course, it won't do much good if those records are still in use.

1) Make sure your EPG XML file only refers to channels you actually want to watch. Unchecking them in GBPVR is too late - they'll still be in the DB3 database.
2) You can't delete channels when you have a recording from that channel. I've been known to fix up the database records directly. You could probably export them, and fix them to refer to a channel you want to keep, delete them from the db3, then reimport them or use vidimport.
3) Make a GBPVR.DB3 backup (make lots of them when trying something new), make your changes, then vacuum.
4) Simplest, safest procedure is to do step 1 then start with empty.db3, rename to gbpvr.db3 and redo your setup of sources and import any recordings with vidimport. There are tools to export complicated BDA source mappings if you need them.

Have fun.

[jksmurf]

Wow, Thanks!

OK,

1. the vaccuum thing I am clear on
   
2. for the XML thing I deleted the XML's for the older channels (I haven't actually deleted the channels, just unchecked them)
   
3. will backup db
   
4. might use the Config Plugins Tab to export the recordings first!
   

Thanks again.... hmm... makes me nervous :o

vidimport? I currently use the GUI based MPEGImport, it is good for making the recording xml for import, but can't import without an error (I'd love someone to fix this!), so I use the config for that too.

k.

[jksmurf]

Well I had a wee play around with SQliteSpy, it was pretty good

I did the empty.db3 thing (after exporting my recording list), all went well, the only bear for me was I lost the setup of the recording sources with all the setting for channel changes etc etc. A lot of other config settings are in config.xml but not those.

sub, is there any way to export and reimport that information only? It would be really great not have to re-set that up again. I have 4 capture sources spread over 3 recording devices, some analog some digital, some user inbuilt tuners and some external recording sources so it gets all a bit complicated to re-input. I have been taking screen capture screems to try and remember it ...

k.

[sub]

sub, is there any way to export and reimport that information only?

Sorry, no there isnt.

[dennit]

Wow, Thanks!

for the XML thing I deleted the XML's for the older channels (I haven't actually deleted the channels, just unchecked them)

You have to make sure that the channels are not in your EPG file. If you've "unchecked them" in whatever source pulls in your EPG, then it will keep them out of your GBPVR DB. If you just unchecked them from GBPVR's config, that won't keep the data out. The channel data and all prgrams will still be in your DB. If you use MC2XML, then you should use the -C channel file option to limit what gets into your DB if you want it kept small.

# -C <filename> set channel file (default = "mc2xml.chl")

[dennit]

I did the empty.db3 thing (after exporting my recording list), all went well, the only bear for me was I lost the setup of the recording sources with all the setting for channel changes etc etc. A lot of other config settings are in config.xml but not those.

As I mentioned, there are export import tools for BDA channel mapping. They help some. I' don't do channel changing.........

is there any way to export and reimport that information only? It would be really great not have to re-set that up again. I have 4 capture sources spread over 3 recording devices, some analog some digital, some user inbuilt tuners and some external recording sources so it gets all a bit complicated to re-input. I have been taking screen capture screems to try and remember it ...

You can always open up your backup gbpvr.db3 and cut/paste into the new one. You can also get fancy and export using SQL, then reimport. SQLiteSpy lets you save your SQL queries, and I've got dozens that do little cleanup tasks or make changes to my db3.

[dennit]

BTW, I assume you wanted this stuff out of your db3 to increase speed. If so, have you read this thread?

[jksmurf]

BTW, I assume you wanted this stuff out of your db3 to increase speed. If so, have you read this thread?

Thanks dennit, no I hadn't seen that, interesting thread. Presume current ver of gbpvr hasn't added this in yet.

Removing the tuner and the EPG XML associated with it seems to have cut it down by a third :-)

k.