TVServer failed to create database

Discussion in 'General Support' started by badboyxx, October 10, 2015.

  1. badboyxx

    badboyxx Portal Pro

    Joined:
    June 15, 2012
    Messages:
    684
    Likes Received:
    53
    Gender:
    Male
    Ratings:
    +86 / 9
    Home Country:
    Germany Germany
    Show System Specs
    I thought I have a failure in my TV database, so I stopped the TVService and MySQL service and deleted the mptvdb folder to create a fresh one. After that I startet the MySQL service again and startet TV-Server config. I got an error with "failed to create database" and the config didn't start. A look into the mptvdb showed me that it created only 27 files. Usually it should be more than 60 files. I can't start TVService service and TV-Server config. Why do I get that error.
    I'm using MP 1.12 and MySQL 5.6.


     
  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
    Really bad idea. :(
    If you're going to delete a database, you should do it the proper way - with SQL (drop schema) or through the DB management GUI (which is generating drop schema SQL for you).

    Probably because you have not properly deleted the database, and now MySQL is confused.

    Try to delete the database properly, and then TV Server may be able to recreate it properly.
     
    • Thank You! Thank You! x 1
  4. badboyxx

    badboyxx Portal Pro

    Joined:
    June 15, 2012
    Messages:
    684
    Likes Received:
    53
    Gender:
    Male
    Ratings:
    +86 / 9
    Home Country:
    Germany Germany
    Show System Specs

    Ok after a delete with "drop database mptvdb;" in the command line the tvserver was able to create a new database.
     
    • Informative Informative x 1
  5. 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
    Great, thanks for reporting the success. :)
     
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!