Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?


share|improve this question
up vote 12 down vote accepted

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 !!!

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

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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