How to manage Total distance value keep in increment when we migrate server / change to different DB

I have recently migrated my server, so my DB moved from one server to another server. we had some downtime(1day). after restart traccar. I have noticed total distance resetted back to 0. How I can manage this.
If i update totalDistance key in attribute column of tc_posstion table will work for very next packet? or i need to update any other key in attribute column?

You have to restart after updating the position. Or to avoid race conditions, you should update distances first and then start Traccar.

Thanks Anton,

first solution : I understood that, i should update total distance in tc_posstion table and restart traccar.
second solution : what you mean update distance?? distance value in tc_posstion table attribute column value? that is only the distance from last geo-point right?

I have one more question, total distance in meter, for small values its float type and larger values in scientific notation. from which value i should keep scientific notation. my case i should add older total distance with latest total distance. in that time i need the max value where i should keep scientific notation and till where i should keep normal float.

I meant total distance.

You just need to make sure it's a valid JSON format.

Sure, Thanks dude