+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: MySQL and database compare. (/showthread.php?tid=361174)
MySQL and database compare. - rappleby28 - 2021-03-06
Hopefully I'm in the correct forum, but if not, please direct me to the proper one. Thanks.
My question would be for someone very familiar with MySQL and database issues. I am in the process of rebuilding my RAID6 array (8x4TB) after multiple Seagate drive failures in the past few months. I am replacing the drives with HGST enterprise drives (5 yr warranty). I got a glimpse of my former array before the rebuild started and it appeared that there could be up to 3TB of data missing. I have over 3000 video files stored on the array so manually checking which ones may be missing would be extremely time consuming.
I have not opened KODI 18.9 since the drive failure because I know that (once the array is again readable) KODI will clean the database to show only the available movies. Is there any way that I can compare two databases (by making a copy of the existing database before restarting KODI), letting KODI clean the original database, and then, by doing the database compare, create a list of the movies that are missing from the recovered and cleaned database.
I'm a TOTAL noob when it comes to MySQL functions so, if you have the time, please lay out the procedure (if it is even possible) step by step. Thank you.