1
bikeman
can't import database
  • 2005/5/26 15:39

  • bikeman

  • Just popping in

  • Posts: 30

  • Since: 2005/5/24


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

Login

Who's Online

85 user(s) are online (57 user(s) are browsing Support Forums)


Members: 0


Guests: 85


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits