Page 1 of 1

can't import sql db

PostPosted: 26. May 2005 14:49
by bikeman
I have created a site based upon xoops in xampp 1.4.9. The site was working fine so I exported the DB using phpmyadmin and tried to import it to my webhost. The import failed.

I created a new blank DB in Xampp and tried to import the DB, it also failed.

I am being told by phpmyadmin #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 'PK' at line 1

ERROR: C1 C2 LEN: 2 3 7211
STR: 

CVS: $Id: sqlparser.lib.php,v 2.23 2004/08/09 01:22:59 lem9 Exp $
MySQL: 4.0.21-debug-log
USR OS, AGENT, VER: Win IE 6.0
PMA: 2.6.0-pl1
PHP VER,OS: 4.3.9 WIN32
LANG: en-iso-8859-1
SQL: PK(Lº2«A¿Y”‡‡test.sqlì½k{Û8’0ú9û<ç?pÔ³#çlb‹us.³Nì\Î8¶×vú²Ó}Ô”HYœP¢†¤ì¸»ó_öëû/_n@

PostPosted: 27. May 2005 00:21
by sckoh
Okay, it shows an error near at 'PK' .

Try at phpmyadmin SQL windows(open sql file, copy contents and paste it on SQL windows).