2011-11-29, 15:25
Hi all,
My wife was trying to be helpful the other day and deleted a bunch of her movies from the NAS where we keep our movie collection without telling me. Unfortunately we have everything in a MySQL database on the NAS, so once she updated the library from XBMC, there's now a whole bunch of movies still appearing in the library that no longer exist on the server.
Is there any easy way to eliminate the missing movies from the MySQL database short of manually going through and comparing the database to the list of movie files in the file system?
My wife was trying to be helpful the other day and deleted a bunch of her movies from the NAS where we keep our movie collection without telling me. Unfortunately we have everything in a MySQL database on the NAS, so once she updated the library from XBMC, there's now a whole bunch of movies still appearing in the library that no longer exist on the server.
Is there any easy way to eliminate the missing movies from the MySQL database short of manually going through and comparing the database to the list of movie files in the file system?