1
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