Merge MariaDB dump-data from two different database sets

[lollozzo]

Fix bad data in energy tab

Hi! I built a query (mysql - mariadb based) usefull to fix all data set from first row. My first row was at 11.00 so start from a posive value, you have to customize this dataset to adapt to your situation: @original_total := 11.25, // starting value, first row, you can set what you want here @first_state := 11.25, // use same value of previous row or a higher value @prev_state := 0, @first_id := 1492, // id of your first row, with sum and state equal to 11.25 in this example @meta_id := 116,…

i fixed it using this query on long and short term statistics tables, my graph seems normal after data fix by query.