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