I encounter this problem very often. Maybe there is a workaround or something i'm not doing right.
In PhpMyAdmin, i try to duplicate a database for testing. But every time, i get an SQL error. i have notice that in the last sql line i see this:
"...) ENGINE = MYISAM AUTO_INCREMENT = 4DEFAULT CHARSET = utf8..."
The problem seam to be that in "AUTO_INCREMENT = 4DEFAULT" there is no space between the number 4 and DEFAULT. So i always get stuck there. Since it is a big DB, it would be more convenient to be able to use phpMyAdmin to copy DB.
Anyone else have this problem?
Any ideas on how to fix it?