Fixed!!
Rather than importing the db into mysql, I simply shortcut and dumped the data files into the data folder.
Since the tables could be read and SELECT was working, I presumed that all was good!
Wrong....
However, a dump, create new db and reload the dump has sorted everything out nicely! I am now up and running....
Hope this 'talk to yourself thread' helps someone else in future!