List:General Discussion« Previous MessageNext Message »
From:Neil Aggarwal Date:May 19 2009 9:28pm
Subject:RE: mysql not able to import mysqldump file
View as plain text  
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:mgainty@stripped] 
> Sent: Tuesday, May 19, 2009 2:37 PM
> To: neil@stripped; mysql@stripped
> 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: neil@stripped
> > To: mysql@stripped
> > 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:gtowey@stripped] 
> > > Sent: Tuesday, May 19, 2009 1:05 PM
> > > To: Neil Aggarwal; mysql@stripped
> > > 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@stripped]
> > > Sent: Tuesday, May 19, 2009 6:56 AM
> > > To: mysql@stripped
> > > 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=1
> > > 
> > > 
> > > 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=1
> > 
> 
> _________________________________________________________________
> 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

Thread
mysql not able to import mysqldump fileNeil Aggarwal19 May
  • RE: mysql not able to import mysqldump fileGavin Towey19 May
    • RE: mysql not able to import mysqldump fileNeil Aggarwal19 May
      • RE: mysql not able to import mysqldump fileMartin Gainty19 May
        • RE: mysql not able to import mysqldump fileNeil Aggarwal19 May