[table] was created with a different version of MySQL and cannot be read

[#1]

Hi there,
Can anyone help?
I thought the migration of my site had gone fairly smoothly - my existing code worked fine once I updated it with the new SQL database host / name / passwords etc
However I'm trying to read / insert data into a new table I've created since the migration  - I can see it in phpMyAdmin and I can successfully run the queries / inserts directly in that tool - but when I try to run exactly the same queries in my code they fail and I get the following mysqli_error:

was created with a different version of MySQL and cannot be read
All my previous tables are reading fine.
Any ideas of what I can do to fix this? I did a quick search on Google but the advice all seemed fairly technical (downgrading the database, re-instally the upgrade on the server...)
I'm an amateur coder, so any advice will have to be fairly basic!

[#2]

How did you create the table? phpMyAdmin?
I have to admit, for the moment I'm ignoring that tool and just using Adminer.
Gabe

[#3]

yes I created it in phpMyAdmin.
just tried dropping the table and rebuilding it using MySqlManager in the Control Panel - that hasn't worked either.
Maybe I'll try Adminer as you suggest.

[#4]

fixed it.
double-checked my host name and it was subtly different to the one in the control panel. Odd that the rest of the site was working - either way its fixed now.

[#5]

I've seen a few of these now.
There were a number of customers who were originally provisioned on MySQL4 database instances. This was later corrected after it was found to cause problems with the phpMyAdmin application install. In some cases it looks like the database instances were upgraded to 5 in the MySQL Manager/Control Panel however some customers' sites were left pointing at the MySQL4 instance