Hey @AndyT – yeah, it doesn’t happen often, but I’ve been bitten by case sensitivity related to MySQL table and column names.
This reply has more info and a link to documentation:
As I understand it, Windows is case insensitive, but issues can arise when changing to a different, unix-y environment and back.
As a general rule of thumb to allow maximum portability, I’d recommend having all the table names for your WordPress sites default to lowercase letters.
Hope that gives you some more context around this wacky issue!