6

I am currently getting the following error while trying to import / restore a mysqldump file:

ERROR 1367 (22007) at line 445: Illegal double '1.79769313486232e+308' 
value found during parsing

I looked at various places online and could not find anything that was similar.

Some background:

I am trying to create a new replication box and the mysqldump is new from another replica box. Both boxes are:

CentOS 5.7 with MySQL 5.0.77-4

Used the following to create the mysqldump:

$ mysqldump --lock-all-tables --all-databases | gzip -9 > mysqldump.sql.gz

The new replication box has nothing on there right now and all the databases / tables are supposed to be created by mysqldump. Any insights?

Thanks!

13

There is current open bug report on this one.

The bug report has a suggested work around at the bottom entry [22 Jan 2010 6:46]:

replace 1.79769313486232e+308 \'1.79769313486232e+308\' -- filename

Give it a Try !!!

| improve this answer | |
  • nice find, Rolando! – Derek Downey Nov 14 '11 at 21:43
  • that helped, thanx a lot!! – I.G. Pascual Jan 9 '12 at 13:15
-1

sed -i "s/1.79769313486232e+308/'1.79769313486232e+308'/g" mysqlDump.sql

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.