Database issues (1 Viewer)

doogle

Portal Pro
October 24, 2008
111
1
Home Country
Ireland Ireland
I'm running MP 1.23 on XP SP3. No major issues for about 5 years. I've had to drop the Mysql database a few times over the last few months, either by using the command line utility, or just uninstalling tv server and reinstalling. The symptoms were that WEBEPG would get stuck at writing data to the db. The latest is that when I go into TV Guide or Recorded TV the data is missing and MP complains of missing label, until I restart the PC.

This wouldn't be such a hassle, except that the webepg channel mappings are not included in the export function. Anyway, I digress.

Is there a case for using MSSQL? or does anyone know of similar issues?
 

mm1352000

Retired Team Member
  • Premium Supporter
  • September 1, 2008
    21,577
    8,224
    Home Country
    New Zealand New Zealand
    Hi doogle

    MSSQL is worth a shot. The MySQL MyISAM tables that TV Server uses are not transactional, so the MSSQL DB may prove more reliable.

    mm
     

    doogle

    Portal Pro
    October 24, 2008
    111
    1
    Home Country
    Ireland Ireland
    After the latest rebuild all is well thusfar. I wonder if a well fragmented drive would have any impact on the db?
     

    Users who are viewing this thread

    Top Bottom