MySQL losing all data for no reason
#1
I have had MySQL database working perfectly for the last year or so but twice over the last 2 weeks MySQL has suddenly dropped all of my movie and tv show data. I have not made any changes to xbmc or the database so I am not sure why this is happening. The first time I assumed maybe I accidentally did something and it didn't drop all the data, just about half of both movie and tv but the second time it completely dropped everything. Does any one have any ideas why this is happening? I lose all my watched metadata and it is annoying to have to completely reload my whole library over and over again.

I keep my files on a drobo nas and have 3 htpcs running frodo. My MySQL database runs on a win7 pc. The files are not affected, just the MySQL database. Not sure if the issue is on MySQL or one of the XBMCs.
Reply
#2
debug log (wiki)
Reply
#3
I'm curious to which version of Xbmc you had running, because i also currently have some problems with MySql and Xbmc 13 Alpha 4.
Reply

Logout Mark Read Team Forum Stats Members Help
MySQL losing all data for no reason0