A phpMyAdmin question, cannot make a copy of table...odd >>>

[SpockBert]

Hi

Using phpMyAdmin for my mySql db which I've used for years when making a backup of a table I used to go to "Operations" - "Copy table to", "Structure and Data", make a name for the new table and voila job done.

Now however whenever I try copying a table I get an error message like:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '209DEFAULT CHARSET = latin1' at line 14

Any ideas what the problem could be? I'm kinda stuck on this.

Thanks

[designforce]

I too had problems several months back.

I used the Table maintenace options available. I ran Check table then Analyze table and finally Optimize table as there were no errors from the first two checks.

After that was completed all worked as it should. My tables contain a fair amount of entries and now I run the above on a more regular basis.

Hope it is just something minor.

Good luck