

I was assuming it was a single file with all the goodies(tables/fields etc) in one file ready to be edited.


I was confused with MySQL Workbench and how to open the database. I opened the mptvdb with MySQL Workbench and opened a local instance of the channel table and found what I was looking for. Yay.I posted in frustration too soon literally, hours too soon. Any suggestions or push in the proper direction (wiki, forum) would be greatly appreciated. I know it's free and I love the tinkering, but having a hard time with the above item. Once I get this going, then I start working on IR Blasting for cable set top box channel changing (found all the wiki pages for this one). I've tried sql lite and MySQL but have not be able to find the database to open. My problem is I can't find the database to manipulate nor the program to open the database. I just want to manually add my analog cable channels within TVserver Configuration program, do a scan, let SD pull whatever it's going to pull down and then enter the database (mptvdb?) and update the channel ID from SchedulesDirect website with the correct channel ID and then update the EPG data with a TVServer restart, and have the channels updated all at once (OTA and CABLE). I was wondering if anyone knew of a wiki page or forum post that could instruct me on how to change the station ID within MediaPortal/SD plugin via the SQL Database? scan, re-scan delete rinse and repeat is not something I want to do with 60 channels of cable and 20 channels of OTA. But my problem is with SD plugin not pulling down the right channel information. Hello, My first post, certainly not the last one I've got mediaportal going with schedules direct over ATSC in canada.
