From: Martin Gainty Date: May 19 2009 7:37pm Subject: RE: mysql not able to import mysqldump file List-Archive: http://lists.mysql.com/mysql/217605 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_df1dc167-56d7-44f3-9817-1134b80b6db0_" --_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_point_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 =FCzenet bizalmas. Ha nem =F6n az akinek sz=E1nva volt=2C akkor k=E9rj=FCk= =2C hogy jelentse azt nek=FCnk vissza. Semmif=E9le tov=E1bb=EDt=E1sa vagy m=E1solat= =E1nak k=E9sz=EDt=E9se nem megengedett. Ez az =FCzenet csak ismeret cser=E9t szol= g=E1l =E9s semmif=E9le jogi alkalmazhat=F3s=E1ga sincs. Mivel az electronikus =FCzene= tek k=F6nnyen megv=E1ltoztathat=F3ak=2C ez=E9rt minket semmi felel=F6s=E9g nem = terhelhet ezen =FCzenet 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@stripped > To: mysql@stripped > 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@stripped]=20 > > Sent: Tuesday=2C May 19=2C 2009 1:05 PM > > To: Neil Aggarwal=3B mysql@stripped > > 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@stripped] > > Sent: Tuesday=2C May 19=2C 2009 6:56 AM > > To: mysql@stripped > > 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@stripped > >=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=2C=20 > > 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@stripped= 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_--