21
bikeman
Is DB backup & restore possible???
  • 2005/5/26 22:04

  • bikeman

  • Just popping in

  • Posts: 30

  • Since: 2005/5/24


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?




22
bikeman
Re: cant import database
  • 2005/5/26 17:34

  • bikeman

  • Just popping in

  • Posts: 30

  • Since: 2005/5/24


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



23
bikeman
can't import database
  • 2005/5/26 15:42

  • 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



24
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



25
bikeman
Re: X_SITEURL and Auto Format bug (blocks admin)
  • 2005/5/26 13:06

  • bikeman

  • Just popping in

  • Posts: 30

  • Since: 2005/5/24


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



26
bikeman
hyperlinks - why is only target 'blank' page
  • 2005/5/26 12:42

  • bikeman

  • Just popping in

  • Posts: 30

  • Since: 2005/5/24


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




TopTop
« 1 2 (3)



Login

Who's Online

209 user(s) are online (45 user(s) are browsing Support Forums)


Members: 0


Guests: 209


more...

Donat-O-Meter

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

Latest GitHub Commits