Results 1 to 1 of 1
Feb 7, 2011, 10:49 #1
- Join Date
- Nov 2005
- 0 Post(s)
- 0 Thread(s)
Error duplicating database in PhpMyAdmin
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?