|
|
Posted by Terry.Biel@gmail.com on 10/21/07 01:58
You 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" <mario.pere...@epi.pt> wrote:
> 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 query
> 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 have
> problems or if the parser fails where the command line interface succeeds,
> please reduce your SQL query input to the single query that causes problems,
> and submit a bug report with the data chunk in the CUT section below:
> ----BEGIN CUT----
> eNp1kj1v2zAQhnf+ihsKeJEUkjL1tTmGm6aVbcVKXSBLcbZkh4EsuvoIkv60/qMOnbp16tEfbYKi
> k/Qej/c+vLvJYjFfJDAWMJaQTmYJhDFEHIJYsfyWTn7VhWkZGy/zBN5cFwm0X6o9Nm3ZeJVeefv7
> vfMI0huGIDkPLri4ECGIMOEy8Tmsn1em+9ztYPK0hzds+pzfpAkMPeFJ7u7wya3Mln3MFzDPHRhd
> TWa3DiwnZPtJ1zCd312n6QiUx1k2HSVkE3ncEyx7l9ksZ57bWr4nBKS67p9YOppdJVDWbt9t3Igd
> zAZi4Ayyn48GoTCwxOar3lFk0SNMse7LCt6b9jtMTVPqBlnab7GBAlvIyqKhz2WD9Zq+bKhC7vpB
> ACkem/JvUakkBJyD8PkrFZPaG8r2HvbbARtI0mNsO6zvramtsdAr7MoHQyc3va67QzAzTWegKGFE
> cOhAaroSFJNU1Q1CBf+vIQMfJM1Rcf5SCavWf295W70hHv/EU1bm+F5b4s7UCNd10bddo7E6YFRr
> 1HXLbPP8E44MwIURrUSHhBD5wIhOuXEcn9MtQCgh5gKU8l+p4QmHjE+tsZG3ZXMYhr05IXcsEGa4
> 1gRUQe19AyGVA2jgww5Cyf6ks4h20FXKOq/6jY1ZtygGFQoQAX+hYhWR2pyvntyVde/r9T1W9HfZ
> aHrUubtLrErIsMEfrWFnLLsoYzwVgZrQuM9y3enD2F5ecVgsfOVyGsMYd0gWYHFiQpGcushfKbsx
> 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 Sitio
> 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óvoa do Varzim','Rua Manuel José Moreira
> Lugar das Pedras
>
> Can someone help me please?
>
> Thanks in advance.
>
> Mário
>
> begin 666 b_help.png
> MB5!.1PT*&@H````-24A$4@````L````+" ,```"><H<4````!&=!34$``*_(
> M-P6*Z0```!ET15AT4V]F='=A<F4`061O8F4@26UA9V5296%D>7')93P````)
> M4$Q410```,S,_P```!>I-"0````#=%).4___`-?*#4$```!3241!5'C:8F!B
> M8H `)B: `&)@8F"$``8F@ !B`#$9("1 `(%(, .(``*(`:($S 4(( @;0@`$
> M$#(;(( 88,8`V0`!A"P.$$#(Y@,$$ .2O0`!!@`7Q0!=OLO%,P````!)14Y$
> $KD)@@@``
> `
> end
Navigation:
[Reply to this message]
|