Updating Metric Names from mixed case to all lower?

Hi all, was hoping someone might help point me in the right direction. When originally set up I used names like “CheckLoad” or “CheckCPU” but recently updated my Nagios config to use all lower case names. Is there a good way to go about updating the names in InfluxDB? I’m a total know-nothing when it comes to query and DB internals, my main thing is I don’t want to lose data, we’ve got almost two years of historical data and I’d really hear about it if I blow it up.
Is there a way to do something like UPDATE old_measurement_name TO new_measurement_name ?

In case anyone else needs to do this I was able to use the following to do what I needed:
SELECT * INTO new_name FROM Old_Name GROUP BY *

1 Like