Sagewire Logo

problems importing tables

2 Message(s) by 2 Author(s) originally posted in php sql


From: news.telepac.pt Date:   Thursday, October 18, 2007
hello

I'm a newbie to sql, and i'm having problems importing table s that I have
exported from another data bases.
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 error s.
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've 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*&@xxxxxxxxxxx````-24A$4@xxxxxxxxxxx````L````+" ,```"><H<4````!&=!34$``*_(
M-P6*Z0```!ET15AT4V]F='=A<F4`061O8F4@xxxxxxxxxxx%D>
7')93P````)
M4$Q410```,S,_P```!>I-"0````#=%).4___`-?*#4$```!3241!5'C:8F!B
M8H `)B: `&)@xxxxxxxxxxx"$``8F@xxxxxxxxxxx !B`#$9("1 `(%(, .(``*(`:($S 4(( @xxxxxxxxxxx;0@xxxxxxxxxxx`$
M$#(;(( 88,8`V0`!A"P.$$#(Y@xxxxxxxxxxx,$$ .2O0`!!@xxxxxxxxxxx`7Q0!=OLO%,P````!)14Y$
$KD)@xxxxxxxxxxx@xxxxxxxxxxx@xxxxxxxxxxx``
`
end


From: Terry.Biel Date:   Saturday, October 20, 2007
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've on your hosting control panel for
exporting the data? Are there options for the export format, such as
"=2Ecsv or comma delimited," anything like that?

-TB

wrote in message:
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/zBN5cFwm0X6o9Nm3ZeJVee=
fv7
vfMI0huGIDkPLri4ECGIMOEy8Tmsn1em+9ztYPK0hzds+pzfpAkMPeFJ7u7wya3Mln3MFzDPH=
Rhd
TWa3DiwnZPtJ1zCd312n6QiUx1k2HSVkE3ncEyx7l9ksZ57bWr4nBKS67p9YOppdJVDWbt9t3=
Igd
zAZi4Ayyn48GoTCwxOar3lFk0SNMse7LCt6b9jtMTVPqBlnab7GBAlvIyqKhz2WD9Zq+bKhC7=
vpB
ACkem/JvUakkBJyD8PkrFZPaG8r2HvbbARtI0mNsO6zvramtsdAr7MoHQyc3va67QzAzTWegK=
GFE
cOhAaroSFJNU1Q1CBf+vIQMfJM1Rcf5SCavWf295W70hHv/EU1bm+F5b4s7UCNd10bddo7E6Y=
FRr
1HXLbPP8E44MwIURrUSHhBD5wIhOuXEcn9MtQCgh5gKU8l+p4QmHjE+tsZG3ZXMYhr05IXcsE=
Ga4
1gRUQe19AyGVA2jgww5Cyf6ks4h20FXKOq/6jY1ZtygGFQoQAX+hYhWR2pyvntyVde/r9T1W9=
HfZ
aHrUubtLrErIsMEfrWFnLLsoYzwVgZrQuM9y3enD2F5ecVgsfOVyGsMYd0gWYHFiQpGcushfK=
bsx
myPIEe03m8oNZg=3D=3D
----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've 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*&@xxxxxxxxxxx````-24A$4@xxxxxxxxxxx````L````+" ,```"><H<4````!&=3D!34$``*_(
M-P6*Z0```!ET15AT4V]F=3D'=3DA<F4`061O8F4@xxxxxxxxxxx%D>
7')93P````)
M4$Q410```,S,_P```!>I-"0````#=3D%).4___`-?*#4$```!3241!5'C:8F!B
M8H `)B: `&)@xxxxxxxxxxx"$``8F@xxxxxxxxxxx !B`#$9("1 `(%(, .(``*(`:($S 4(( @xxxxxxxxxxx;0@xxxxxxxxxxx`$
M$#(;(( 88,8`V0`!A"P.$$#(Y@xxxxxxxxxxx,$$ .2O0`!!@xxxxxxxxxxx`7Q0!=3DOLO%,P````!)14Y$
$KD)@xxxxxxxxxxx@xxxxxxxxxxx@xxxxxxxxxxx``
`


> end



Next Message: What's wrong with this?


Blogs related to problems importing tables

Im changing how php I refer to some modules and I would like to ...
problem with python is that it’s easy to end up with lots of silly NameErrors that then pop up at runtime, the rapid development time is offset by the time needed to write lots of unit tests. you pussies. ...

phpeditors linuxbackup
... config.inc phpmyadmin config.inc.php phpmyadmin configuration phpmyadmin configure phpmyadmin connect phpmyadmin connection phpmyadmin control user phpmyadmin create table phpmyadmin create user phpmyadmin csv phpmyadmin csv import ...

Help! Problems importing unicode filenames :: Helium Music Manager ...
The individual Helium table columns all appear to be UTF8/UTF8_GENERAL_CI (at least in the tblalbums and tblartists tables, and I'm assuming the same in the other tables). But I can't seem to import existing unicode and non-western ...

that did it web mail the default group settingthough I dont know ...
Please contact an administrator if this problem persists. syntax error, unexpected $end in /mounted-storage/home70c/sub002/sc41020-JIPV/claneasycompany.com/forums/config.php on line 18 now when i changed it back i get this damm whats ...

Im currently using webmail utf8_unicode_ci collation and it seems ...
well technically this is a php problem and a basic programming task known as “debugging” now… follow the data to its source. Put print statements all over to check and make sure that variables actually contain what you think they do ...

php image gif
php image gif php image graph php image handling php image header php image headers php image height php image host php image host 1.0 php image host script php image host v1.0 php image hosting php image hosting script php image jpeg ...


Programming | Sports | Autos

copyright 2006
Valid XHTML 1.0 Transitional