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.
> -----Original Message-----
> From: Martin Gainty [mailto:[email protected]]
> Sent: Tuesday, May 19, 2009 2:37 PM
> To: [email protected]; [email protected]
> Subject: RE: mysql not able to import mysqldump file
>
>
> Neil-
>
> http://wiki.seas.harvard.edu/geos-chem/index.php/Floating_poin
t_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
> ______________________________________________
> Jogi és Bizalmassági kinyilatkoztatás/Verzicht und
> Vertraulichkeitanmerkung/Note de déni et de confidentialité
> Ez az
> üzenet bizalmas. Ha nem ön az akinek szánva volt, akkor kérjük, hogy
> jelentse azt nekünk vissza. Semmiféle továbbítása vagy másolatának
> készítése nem megengedett. Ez az üzenet csak ismeret cserét
> szolgál és
> semmiféle jogi alkalmazhatósága sincs. Mivel az electronikus üzenetek
> könnyen megváltoztathatóak, ezért minket semmi felelöség nem terhelhet
> ezen üzenet tartalma miatt.
>
> Diese Nachricht ist vertraulich. Sollten Sie nicht der
> vorgesehene Empfaenger sein, so bitten wir hoeflich um eine
> Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer
> Kopie ist unzulaessig. Diese Nachricht dient lediglich dem
> Austausch von Informationen und entfaltet keine rechtliche
> Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von
> E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
> Ce message est confidentiel et peut être privilégié. Si vous
> n'êtes pas le destinataire prévu, nous te demandons avec
> bonté que pour satisfaire informez l'expéditeur. N'importe
> quelle diffusion non autorisée ou la copie de ceci est
> interdite. Ce message sert à l'information seulement et
> n'aura pas n'importe quel effet légalement obligatoire. Étant
> donné que les email peuvent facilement être sujets à la
> manipulation, nous ne pouvons accepter aucune responsabilité
> pour le contenu fourni.
>
>
>
>
> > From: [email protected]
> > To: [email protected]
> > Subject: RE: mysql not able to import mysqldump file
> > Date: Tue, 19 May 2009 13:40:43 -0500
> >
> > 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:[email protected]]
> > > Sent: Tuesday, May 19, 2009 1:05 PM
> > > To: Neil Aggarwal; [email protected]
> > > 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:[email protected]]
> > > Sent: Tuesday, May 19, 2009 6:56 AM
> > > To: [email protected]
> > > 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/[email protected]
> > >
> > >
> > > 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/[email protected]
> >
>
> _________________________________________________________________
> Hotmail® has a new way to see what's up with your friends.
> http://windowslive.com/Tutorial/Hotmail/WhatsNew?ocid=TXT_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/[email protected]
