Re: problems importing tables
am 21.10.2007 03:58:36 von Terry.BielYou need to be more clear about what query you're attempting. Is the
"SQL query" you posted the one you're trying to execute in phpmyadmin?
If so, it's not formatted to be executed as a SQL query at all.
Also, what options do you have on your hosting control panel for
exporting the data? Are there options for the export format, such as
"csv or comma delimited," anything like that?
-TB
On Oct 18, 7:08 am, "news.telepac.pt"
> hello
>
> I'm a newbie to sql, and i'm having problems importing tables that i have
> exported from another databases.
> The problem is that i cannot export the db dump, instead i just the chance
> to export table by table through the hosting control pannel.
> Then i went to the new hosting server through php MyAdmin and tried to
> import table by table and it give errors.
> Here is an example of an error:
>
> Error
> There is a chance that you may have found a bug in the SQL parser. Please
> examine your query closely, and check that the quotes are correct and not
> mis-matched. Other possible failure causes may be that you are uploading a
> file with binary outside of a quoted text area. You can also try your que=
ry
> on the MySQL command line interface. The MySQL server error output below,=
if
> there is any, may also help you in diagnosing the problem. If you still h=
ave
> problems or if the parser fails where the command line interface succeeds,
> please reduce your SQL query input to the single query that causes proble=
ms,
> and submit a bug report with the data chunk in the CUT section below:
> ----BEGIN CUT----
> eNp1kj1v2zAQhnf+ihsKeJEUkjL1tTmGm6aVbcVKXSBLcbZkh4EsuvoIkv60 /qMOnbp16tEfb=
YKi
> k/Qej/c+vLvJYjFfJDAWMJaQTmYJhDFEHIJYsfyWTn7VhWkZGy/zBN5cFwm0 X6o9Nm3ZeJVee=
fv7
> vfMI0huGIDkPLri4ECGIMOEy8Tmsn1em+9ztYPK0hzds+pzfpAkMPeFJ7u7w ya3Mln3MFzDPH=
Rhd
> TWa3DiwnZPtJ1zCd312n6QiUx1k2HSVkE3ncEyx7l9ksZ57bWr4nBKS67p9Y OppdJVDWbt9t3=
Igd
> zAZi4Ayyn48GoTCwxOar3lFk0SNMse7LCt6b9jtMTVPqBlnab7GBAlvIyqKh z2WD9Zq+bKhC7=
vpB
> ACkem/JvUakkBJyD8PkrFZPaG8r2HvbbARtI0mNsO6zvramtsdAr7MoHQyc3 va67QzAzTWegK=
GFE
> cOhAaroSFJNU1Q1CBf+vIQMfJM1Rcf5SCavWf295W70hHv/EU1bm+F5b4s7U CNd10bddo7E6Y=
FRr
> 1HXLbPP8E44MwIURrUSHhBD5wIhOuXEcn9MtQCgh5gKU8l+p4QmHjE+tsZG3 ZXMYhr05IXcsE=
Ga4
> 1gRUQe19AyGVA2jgww5Cyf6ks4h20FXKOq/6jY1ZtygGFQoQAX+hYhWR2pyv ntyVde/r9T1W9=
HfZ
> aHrUubtLrErIsMEfrWFnLLsoYzwVgZrQuM9y3enD2F5ecVgsfOVyGsMYd0gW YHFiQpGcushfK=
bsx
> myPIEe03m8oNZg==
> ----END CUT----
> ----BEGIN RAW----
>
> ERROR: C1 C2 LEN: 79 80 695
> STR: ?ndos
>
> CVS: $Id: sqlparser.lib.php,v 2.47 2006/01/17 17:02:30 cybot_tm Exp $
> MySQL: 4.1.20-max-log
> USR OS, AGENT, VER: Win MOZILLA 5.0
> PMA: 2.8.0.1
> PHP VER,OS: 4.3.11 Linux
> LANG: en-utf-8
> SQL: '1','P?voa do Varzim','Rua Manuel Jos? Moreira
> Lugar das Pedras Brancas
> 4570-366 La?ndos
> P?voa do Varzim','252 600 130','252 600 139','povoa.jpg'
> '2','Castanheira do Ribatejo','Quinta do Porto de Areia, Lote 5
> 2600-675 Castanheira do Ribatejo','263 280 500','263 280
> 510','castanheira.gif'
> '3','Castelo Branco','Zona Industrial de Alcains
> Rua 3, Lote 26 - Apartado 83
> 6005-999 Alcains','272 901 553','272 901 554','castelo.jpg'
> '4','Ferreiras','Estrada Nacional n.? 125, ao Km 72
> Ferreiras
> 8200-559 Albufeira','289 571 160','289 571 958','ferreiras.jpg'
> '5','Funchal','Britadeira do Vale Para?so
> Estrada das Carreiras n? 103
> Sitio de Vale Para?so,
> 9135-080 Camacha ','291 920 260','291 920 269','funchal.jpg'
> ----END RAW----
>
> SQL query:
>
> '1','P?voa do Varzim','Rua Manuel Jos? Moreira Lugar das Pedras Brancas
> 4570-366 La?ndos P?voa do Varzim','252 600 130','252 600 139','povoa.jpg'
> '2','Castanheira do Ribatejo','Quinta do Porto de Areia, Lote 5 2600-675
> Castanheira do Ribatejo','263 280 500','263 280 510','castanheira.gif'
> '3','Castelo Branco','Zona Industrial de Alcains Rua 3, Lote 26 - Apartado
> 83 6005-999 Alcains','272 901 553','272 901 554','castelo.jpg'
> '4','Ferreiras','Estrada Nacional n.? 125, ao Km 72 Ferreiras 8200-559
> Albufeira','289 571 160','289 571 958','ferreiras.jpg'
> '5','Funchal','Britadeira do Vale Para?so Estrada das Carreiras n? 103 Si=
tio
> de Vale Para?so, 9135-080 Camacha ','291 920 260','291 920
> 269','funchal.jpg'
>
> 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
> ''1','P=F3voa do Varzim','Rua Manuel Jos=E9 Moreira
> Lugar das Pedras
>
> Can someone help me please?
>
> Thanks in advance.
>
> M=E1rio
>
> begin 666 b_help.png
> MB5!.1PT*&@H````-24A$4@````L````+" ,```">
> M4$Q410```,S,_P```!>I-"0````#=3D%).4___`-?*#4$```!3241!5'C:8 F!B
> M8H `)B: `&)@8F"$``8F@ !B`#$9("1 `(%(, .(``*(`:($S 4(( @;0@`$
> M$#(;(( 88,8`V0`!A"P.$$#(Y@,$$ .2O0`!!@`7Q0!=3DOLO%,P````!)14Y$
> $KD)@@@``
> `
> end