[tret]

Fixed:

When upgrading from "Eden" to "Frodo" I didn't consider that the sql database structure of the video database itself may have changed and just "plugged in" to the existing database created by "Eden".

Here's what I did to resolve the issue:

1. Using mysql, I "dropped" (effectively deleted) the old "Eden" databases
2. I booted my main htpc running Frodo beta 1 and re-setup my TV Show and Movies databases
Note: Interestingly, 2x sql databases were created whereas in "Eden" there was 1x database shared for both TV Shows and Movies
3. I booted the secondary htpc running Frodo beta 1 and Bingo... Almost... The TV shows database was there however the Movies database was not
4. I added both sql databases as <videodatabase> entries in advancedsettings.xml using the <name> tag to specify them, see below. This did the trick. Both TV Shows and Movies working/synced on both Frodo HTPC's. Fanart/Posters/etc. synced as well.

Code:

<videodatabase>
    <type>mysql</type>
    <name>MyVideos72</name>
    <host>sqldb</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
  </videodatabase>
  <videodatabase>
    <type>mysql</type>
    <name>MyVideos73</name>
    <host>sqldb</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
  </videodatabase>

Rob