Just thought I’d drop a quick update, I have my site back up and it was the backup creator which was the issue. Followed the instructions above:
1.swapped the plugins folder to plugins.pak
2. changed theme in phpmyadmin to twentyten
3. my site was viewable again
4. logged into my wordpress dashboard and deleted backup creator
5. changed my plugins folder back to plugins
6. swapped my theme back
7. All sorted and panic over!
I was on wordpress 3.3.1 and using backup creator 1.08/9D.
Still no word from backup creator although my hosting company (www.unlimitedwebhosting.co.uk), as always, were super helpful.
Thanks for the info james and papa, lifesavers! ??