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:mgai...@hotmail.com] > Sent: Tuesday, May 19, 2009 2:37 PM > To: n...@jammconsulting.com; mysql@lists.mysql.com > 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: n...@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 > > > > 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:gto...@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:n...@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=gto...@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=mgai...@hotmail.com > > > > _________________________________________________________________ > 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/mysql?unsub=arch...@jab.org