I tried to copy a mysql database with several gigabytes of data and suddenly the receiving end chokes on a ‘nan’.

Nani?

Well apparently earlier versions of mysql supported ‘nan’ and ‘inf’ as valid float values but newer versions don’t as they abide by the SQL standard which states:

‘Thou shalt not NaN’

And thus it’s in the data [...]