OK I'm back.
It seems you need 'SPECIAL' Privileges to run Events, which I understand are not provided in shared hosting accts.
So I'm having another crack at cron.
Previously I tried running my script with PDO, this seems to be not visible by cron, I think php.ini for cron is not enabled and I cant' (obviously ) edit php.ini in cPanel.
So I've made a retro-grade step and I'm now trying mysql_connect (Old School Shit), this also fails, for god knows why reason.
The error reported:
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
I am getting seriously pissed-off with this crap, all I want to do is automate a db table to be restored to its original content once a day.
It seems this is an impossible task at the moment.
I've now raised a ticket with LP, hopefully they can resolve this annoying problem and I can get back to doing something more productive.
Thanks again for your assistance