mysql not able to import mysqldump file

Hello:

I have a database with several double columns
in the tables.

I used mysqldump to dump the data from the primary
database and I am trying to import it into a
secondary database.

I am importing the data by passing the generated
sql file to the mysql command line client.

When I do that, I am getting this error:

Illegal double '1.79769313486232e+308' value found during parsing

Any ideas how to fix this?

Thanks,
Neil


--
Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com
Eliminate junk email and reclaim your inbox.
Visit http://www.spammilter.com for details.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: mysql not able to import mysqldump file

Hi Niel,

What version is the mysql dump from? Are you importing to a different vers=
ion?

Could you show the line from the file that is generating the error?

Regards,
Gavin Towey


-----Original Message-----
From: Neil Aggarwal [mailto:neil@JAMMConsulting.com]
Sent: Tuesday, May 19, 2009 6:56 AM
To: mysql@lists.mysql.com
Subject: mysql not able to import mysqldump file

Hello:

I have a database with several double columns
in the tables.

I used mysqldump to dump the data from the primary
database and I am trying to import it into a
secondary database.

I am importing the data by passing the generated
sql file to the mysql command line client.

When I do that, I am getting this error:

Illegal double '1.79769313486232e+308' value found during parsing

Any ideas how to fix this?

Thanks,
Neil


--
Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com
Eliminate junk email and reclaim your inbox.
Visit http://www.spammilter.com for details.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgtowey@ffn.com


The information contained in this transmission may contain privileged and c=
onfidential information. It is intended only for the use of the person(s) n=
amed above. If you are not the intended recipient, you are hereby notified =
that any review, dissemination, distribution or duplication of this communi=
cation is strictly prohibited. If you are not the intended recipient, pleas=
e contact the sender by reply email and destroy all copies of the original =
message.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: mysql not able to import mysqldump file

Gavin:

Both servers are mysql-server.x86_64 5.0.45-7.el5
installed using yum on CentOS 5.

I was able to work around it by doing a global replace
of that string with 1.79769313486e+308 since it apparently
just barely exceeded the max double value.

The values were originally stored using the
Java Double.MAX_VALUE constant over JDBC.

There should not be this inconsistency between
what mysqldump creates and what the server can
handle since the platform and version are exactly
the same.

Having said that, there is an easy fix so it is
not a big deal.

Thanks,
Neil

--
Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com
Eliminate junk email and reclaim your inbox.
Visit http://www.spammilter.com for details.

> -----Original Message-----
> From: Gavin Towey [mailto:gtowey@ffn.com]
> Sent: Tuesday, May 19, 2009 1:05 PM
> To: Neil Aggarwal; mysql@lists.mysql.com
> Subject: RE: mysql not able to import mysqldump file
>
> Hi Niel,
>
> What version is the mysql dump from? Are you importing to a
> different version?
>
> Could you show the line from the file that is generating the error?
>
> Regards,
> Gavin Towey
>
>
> -----Original Message-----
> From: Neil Aggarwal [mailto:neil@JAMMConsulting.com]
> Sent: Tuesday, May 19, 2009 6:56 AM
> To: mysql@lists.mysql.com
> Subject: mysql not able to import mysqldump file
>
> Hello:
>
> I have a database with several double columns
> in the tables.
>
> I used mysqldump to dump the data from the primary
> database and I am trying to import it into a
> secondary database.
>
> I am importing the data by passing the generated
> sql file to the mysql command line client.
>
> When I do that, I am getting this error:
>
> Illegal double '1.79769313486232e+308' value found during parsing
>
> Any ideas how to fix this?
>
> Thanks,
> Neil
>
>
> --
> Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com
> Eliminate junk email and reclaim your inbox.
> Visit http://www.spammilter.com for details.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=gtowey@ffn.com
>
>
> The information contained in this transmission may contain
> privileged and confidential information. It is intended only
> for the use of the person(s) named above. If you are not the
> intended recipient, you are hereby notified that any review,
> dissemination, distribution or duplication of this
> communication is strictly prohibited. If you are not the
> intended recipient, please contact the sender by reply email
> and destroy all copies of the original message.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: mysql not able to import mysqldump file

--_df1dc167-56d7-44f3-9817-1134b80b6db0_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Neil-

http://wiki.seas.harvard.edu/geos-chem/index.php/Floating_po int_math_issues
so a value this large or small would only be true for 8byte double datatype
Curious as to what the original Table/Column datatype is

hth
Martin=20
______________________________________________=20
Jogi =E9s Bizalmass=E1gi kinyilatkoztat=E1s/Verzicht und Vertraulichkeitanm=
erkung/Note de d=E9ni et de confidentialit=E9
Ez az
üzenet bizalmas. Ha nem ön az akinek sz=E1nva volt=2C akkor k=E9rjük=
=2C hogy
jelentse azt nekünk vissza. Semmif=E9le tov=E1bb=EDt=E1sa vagy m=E1solat=
=E1nak
k=E9sz=EDt=E9se nem megengedett. Ez az üzenet csak ismeret cser=E9t szol=
g=E1l =E9s
semmif=E9le jogi alkalmazhat=F3s=E1ga sincs. Mivel az electronikus üzene=
tek
könnyen megv=E1ltoztathat=F3ak=2C ez=E9rt minket semmi felelös=E9g nem =
terhelhet
ezen üzenet tartalma miatt.

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng=
er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter=
leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l=
ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin=
dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w=
ir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAtes=
pas le destinataire pr=E9vu=2C nous te demandons avec bont=E9 que pour sat=
isfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e=
ou la copie de ceci est interdite. Ce message sert =E0 l'information seule=
ment et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant d=
onn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation=
=2C nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni=
..




> From: neil@JAMMConsulting.com
> To: mysql@lists.mysql.com
> Subject: RE: mysql not able to import mysqldump file
> Date: Tue=2C 19 May 2009 13:40:43 -0500
>=20
> Gavin:
>=20
> Both servers are mysql-server.x86_64 5.0.45-7.el5
> installed using yum on CentOS 5.
>=20
> I was able to work around it by doing a global replace
> of that string with 1.79769313486e+308 since it apparently
> just barely exceeded the max double value.
>=20
> The values were originally stored using the
> Java Double.MAX_VALUE constant over JDBC.
>=20
> There should not be this inconsistency between
> what mysqldump creates and what the server can
> handle since the platform and version are exactly
> the same.
>=20
> Having said that=2C there is an easy fix so it is
> not a big deal.
>=20
> Thanks=2C
> Neil
>=20
> --
> Neil Aggarwal=2C (832)245-7314=2C www.JAMMConsulting.com
> Eliminate junk email and reclaim your inbox.
> Visit http://www.spammilter.com for details. =20
>=20
> > -----Original Message-----
> > From: Gavin Towey [mailto:gtowey@ffn.com]=20
> > Sent: Tuesday=2C May 19=2C 2009 1:05 PM
> > To: Neil Aggarwal=3B mysql@lists.mysql.com
> > Subject: RE: mysql not able to import mysqldump file
> >=20
> > Hi Niel=2C
> >=20
> > What version is the mysql dump from? Are you importing to a=20
> > different version?
> >=20
> > Could you show the line from the file that is generating the error?
> >=20
> > Regards=2C
> > Gavin Towey
> >=20
> >=20
> > -----Original Message-----
> > From: Neil Aggarwal [mailto:neil@JAMMConsulting.com]
> > Sent: Tuesday=2C May 19=2C 2009 6:56 AM
> > To: mysql@lists.mysql.com
> > Subject: mysql not able to import mysqldump file
> >=20
> > Hello:
> >=20
> > I have a database with several double columns
> > in the tables.
> >=20
> > I used mysqldump to dump the data from the primary
> > database and I am trying to import it into a
> > secondary database.
> >=20
> > I am importing the data by passing the generated
> > sql file to the mysql command line client.
> >=20
> > When I do that=2C I am getting this error:
> >=20
> > Illegal double '1.79769313486232e+308' value found during parsing
> >=20
> > Any ideas how to fix this?
> >=20
> > Thanks=2C
> > Neil
> >=20
> >=20
> > --
> > Neil Aggarwal=2C (832)245-7314=2C www.JAMMConsulting.com
> > Eliminate junk email and reclaim your inbox.
> > Visit http://www.spammilter.com for details.
> >=20
> >=20
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgtowey@ffn.com
> >=20
> >=20
> > The information contained in this transmission may contain=20
> > privileged and confidential information. It is intended only=20
> > for the use of the person(s) named above. If you are not the=20
> > intended recipient=2C you are hereby notified that any review,
> > dissemination=2C distribution or duplication of this=20
> > communication is strictly prohibited. If you are not the=20
> > intended recipient=2C please contact the sender by reply email=20
> > and destroy all copies of the original message.
>=20
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmgainty@hotmail.c=
om
>=20

____________________________________________________________ _____
Hotmail=AE has a new way to see what's up with your friends.
http://windowslive.com/Tutorial/Hotmail/WhatsNew?ocid=3DTXT_ TAGLM_WL_HM_Tut=
orial_WhatsNew1_052009=

--_df1dc167-56d7-44f3-9817-1134b80b6db0_--

RE: mysql not able to import mysqldump file

Martin:

Both tables have double for the column.

Neil

--
Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com
Eliminate junk email and reclaim your inbox.
Visit http://www.spammilter.com for details. =20

> -----Original Message-----
> From: Martin Gainty [mailto:mgainty@hotmail.com]=20
> Sent: Tuesday, May 19, 2009 2:37 PM
> To: neil@JAMMConsulting.com; mysql@lists.mysql.com
> Subject: RE: mysql not able to import mysqldump file
>=20
>=20
> Neil-
>=20
> http://wiki.seas.harvard.edu/geos-chem/index.php/Floating_po in
t_math_issues
> so a value this large or small would only be true for 8byte=20
> double datatype
> Curious as to what the original Table/Column datatype is
>=20
> hth
> Martin=20
> ______________________________________________=20
> Jogi =E9s Bizalmass=E1gi kinyilatkoztat=E1s/Verzicht und=20
> Vertraulichkeitanmerkung/Note de d=E9ni et de confidentialit=E9
> Ez az
> üzenet bizalmas. Ha nem ön az akinek sz=E1nva volt, akkor =
k=E9rjük, hogy
> jelentse azt nekünk vissza. Semmif=E9le tov=E1bb=EDt=E1sa vagy =
m=E1solat=E1nak
> k=E9sz=EDt=E9se nem megengedett. Ez az üzenet csak ismeret cser=E9t =

> szolg=E1l =E9s
> semmif=E9le jogi alkalmazhat=F3s=E1ga sincs. Mivel az electronikus =
üzenetek
> könnyen megv=E1ltoztathat=F3ak, ez=E9rt minket semmi felelös=E9g =
nem terhelhet
> ezen üzenet tartalma miatt.
>=20
> Diese Nachricht ist vertraulich. Sollten Sie nicht der=20
> vorgesehene Empfaenger sein, so bitten wir hoeflich um eine=20
> Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer=20
> Kopie ist unzulaessig. Diese Nachricht dient lediglich dem=20
> Austausch von Informationen und entfaltet keine rechtliche=20
> Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von=20
> E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
> Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous=20
> n'=EAtes pas le destinataire pr=E9vu, nous te demandons avec=20
> bont=E9 que pour satisfaire informez l'exp=E9diteur. N'importe=20
> quelle diffusion non autoris=E9e ou la copie de ceci est=20
> interdite. Ce message sert =E0 l'information seulement et=20
> n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant=20
> donn=E9 que les email peuvent facilement =EAtre sujets =E0 la=20
> manipulation, nous ne pouvons accepter aucune responsabilité
> pour le contenu fourni.
>=20
>=20
>=20
>=20
> > From: neil@JAMMConsulting.com
> > To: mysql@lists.mysql.com
> > Subject: RE: mysql not able to import mysqldump file
> > Date: Tue, 19 May 2009 13:40:43 -0500
> >=20
> > Gavin:
> >=20
> > Both servers are mysql-server.x86_64 5.0.45-7.el5
> > installed using yum on CentOS 5.
> >=20
> > I was able to work around it by doing a global replace
> > of that string with 1.79769313486e+308 since it apparently
> > just barely exceeded the max double value.
> >=20
> > The values were originally stored using the
> > Java Double.MAX_VALUE constant over JDBC.
> >=20
> > There should not be this inconsistency between
> > what mysqldump creates and what the server can
> > handle since the platform and version are exactly
> > the same.
> >=20
> > Having said that, there is an easy fix so it is
> > not a big deal.
> >=20
> > Thanks,
> > Neil
> >=20
> > --
> > Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com
> > Eliminate junk email and reclaim your inbox.
> > Visit http://www.spammilter.com for details. =20
> >=20
> > > -----Original Message-----
> > > From: Gavin Towey [mailto:gtowey@ffn.com]=20
> > > Sent: Tuesday, May 19, 2009 1:05 PM
> > > To: Neil Aggarwal; mysql@lists.mysql.com
> > > Subject: RE: mysql not able to import mysqldump file
> > >=20
> > > Hi Niel,
> > >=20
> > > What version is the mysql dump from? Are you importing to a=20
> > > different version?
> > >=20
> > > Could you show the line from the file that is generating=20
> the error?
> > >=20
> > > Regards,
> > > Gavin Towey
> > >=20
> > >=20
> > > -----Original Message-----
> > > From: Neil Aggarwal [mailto:neil@JAMMConsulting.com]
> > > Sent: Tuesday, May 19, 2009 6:56 AM
> > > To: mysql@lists.mysql.com
> > > Subject: mysql not able to import mysqldump file
> > >=20
> > > Hello:
> > >=20
> > > I have a database with several double columns
> > > in the tables.
> > >=20
> > > I used mysqldump to dump the data from the primary
> > > database and I am trying to import it into a
> > > secondary database.
> > >=20
> > > I am importing the data by passing the generated
> > > sql file to the mysql command line client.
> > >=20
> > > When I do that, I am getting this error:
> > >=20
> > > Illegal double '1.79769313486232e+308' value found during parsing
> > >=20
> > > Any ideas how to fix this?
> > >=20
> > > Thanks,
> > > Neil
> > >=20
> > >=20
> > > --
> > > Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com
> > > Eliminate junk email and reclaim your inbox.
> > > Visit http://www.spammilter.com for details.
> > >=20
> > >=20
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe: =20
> http://lists.mysql.com/mysql?unsub=3Dgtowey@ffn.com
> > >=20
> > >=20
> > > The information contained in this transmission may contain=20
> > > privileged and confidential information. It is intended only=20
> > > for the use of the person(s) named above. If you are not the=20
> > > intended recipient, you are hereby notified that any review,=20
> > > dissemination, distribution or duplication of this=20
> > > communication is strictly prohibited. If you are not the=20
> > > intended recipient, please contact the sender by reply email=20
> > > and destroy all copies of the original message.
> >=20
> >=20
> > --=20
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: =20
> http://lists.mysql.com/mysql?unsub=3Dmgainty@hotmail.com
> >=20
>=20
> ____________________________________________________________ _____
> Hotmail=AE has a new way to see what's up with your friends.
> http://windowslive.com/Tutorial/Hotmail/WhatsNew?ocid=3DTXT_ TAGL
M_WL_HM_Tutorial_WhatsNew1_052009


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg