A torrential deluge of rain which caused severe flooding and €10m of damage last month was tonight described as a one-in-650 year event.