I have created my XOOPS site locally and now want to deploy to my isp. I have used phpmyadmin to export my db. When I try to import the db it fails and I get the following:

----BEGIN RAW----

ERROR: C1 C2 LEN: 2 3 381
STR: 

CVS: $Id: sqlparser.lib.php,v 1.1.1.1 2004/08/23 15:41:02 zaphod Exp $
MySQL: 4.0.24_Debian-2
USR OS, AGENT, VER: Win IE 6.0
PMA: 2.5.3-rc1
PHP VER,OS: 4.3.10-9 Linux
LANG: en-iso-8859-1
SQL: PKä?º2ˆ9¡HŽ‹
ÔÊ
cogia.net.sql.zip.sqlì½k{ÛÈ‘0úy÷yö? š}–¹!Ò-fðV÷±:¡ù5á›æã G•"ßÙ¨(›Õq͹6U×ÎT*lànTa‚=/_Ü?}…’‹
Œm£Z‘ï ×Ò‡k£)Œ¯ãEZ#ý5Źì]s£Ò­?J·7*Ý)WÚs™S¨`³¨à…}&Ž†‚Ù.d\Y4
„>6ÝucbL”Ñ'žëØÈp«ý¤JN&ó`ZÌ8¦³Ä…Î0£(€õN—á2Ïûb—êwLw¥•äÚ6F¦ëŠñ*Ÿ‚î‘Õµêcša³&X”!"Rªtá…·(xá…å
ûÞøαçvX†¢TÚóÇ:óµ×ÍqÔ¾¾÷”µg6…
zjn†¥+øá]8‹æ£2”ñÅLR « ²ðƒp,o2Þù¶J ÂW{²,5,æòN¾|´sËfc----END RAW----

SQL-query :

PKä?º2ˆ9¡HŽ‹
ÔÊ cogia.net.sql.zip.sqlì½k{ÛÈ‘0úy÷yö? š}–¹!Ò-fðV÷±:¡ù5á›æã G•"ßÙ¨(›Õq͹6U×ÎT*lànTa‚=/_Ü?}…’‹ Œm£Z‘ï ×Ò‡k£)Œ¯ãEZ#ý5Źì]s£Ò­?J·7*Ý)WÚs™S¨`³¨à…}&Ž†‚Ù.d\Y4 „>6ÝucbL”Ñ'žëØÈp«ý¤JN&ó`ZÌ8¦³Ä…Î0£(€õN—á2Ïûb—êwLw¥•äÚ6F¦ëŠñ*Ÿ‚î‘Õµêcša³&X”!"Rªtá…·(xá…å
ûÞøαçvX†¢TÚóÇ:óµ×ÍqÔ¾¾÷”µg6… zjn†¥+øá]8‹æ£2”ñÅLR « ²ðƒp,o2Þù¶J ÂW{²,5,æòN¾|´sËfc

MySQL said:

#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

I have also tested by settiong up a test XOOPS site on my isp, exportinmg and importing this db also fails.

Can someone help - why can't I import my XOOPS db? thanks

looks like the character sets are different.. how are you exporting/importing them?

I have tried every which way with phpmyadmin - zip, csv etc etc none work

Did you look at the file exported from phpMyAdmin to see if there's anything odd in it?

An alternative to exporting from phpMyAdmin is to use the mysqldump command from the console.