Database issues

Discussion in 'Television (MyTV frontend and TV-Server)' started by doogle, August 9, 2012.

  1. doogle

    doogle Portal Pro

    Joined:
    October 24, 2008
    Messages:
    111
    Likes Received:
    1
    Ratings:
    +1 / 0
    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?
     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. mm1352000
    • Team MediaPortal

    mm1352000 Development Group

    Joined:
    September 1, 2008
    Messages:
    21,527
    Likes Received:
    4,738
    Ratings:
    +8,205 / 17
    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
     
  4. doogle

    doogle Portal Pro

    Joined:
    October 24, 2008
    Messages:
    111
    Likes Received:
    1
    Ratings:
    +1 / 0
    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?
     
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!