List:General Discussion« Previous MessageNext Message »
From:Neil Aggarwal Date:May 19 2009 6:40pm
Subject:RE: mysql not able to import mysqldump file
View as plain text  
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.

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