I have updated the mysql database to 5.7 and the tables are now there. So should all be good. Thanks once again for your help.
Cheers for the help Brajesh, I have spoken to my hosting provider and I will be updating the MySQL database this evening. I will let you know if there is still an issue.
Thanks a lot for the prompt responses.