I have tried many times, on several hosts (including my own apache server) to export my db via phpmyadmin and then restore it. Whatever format I use for export the import fails with:

#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

Is this a bug? Where exactly is my syntax problem? How can an export of a perfectly working site fail to import?

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

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

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

What should I use to make this change? If I use notepad I lose the doc formatting the XOOPS stops working.

I think I must be missing something but why are there no target options for hyperlinks? How do you link to a page without bringing up the page in a new window?

Thanks