meteohub.de

Posted: **Fri Dec 21, 2018 9:34 pm**

Hi,
Unfortunately something weird happened to my mysql database and the most important table got corrupted. It is the table with all the weatherdata stored every minute. I wrote a script that automatically imports the wswintoday.csv every day.

Is there a way to create something like the wswintoday for ALL database entries?
Currently I am at ~1,5 Million entries (>1000 days).

My idea was to just manually create the monthly csvs via the meteohub interface, but for some reason, I can only do that for a few selected months (why is that?) see screenshot.

: export.png (4.78 KiB) Viewed 3223 times

PS: yes, my mysql backup was bad.... *stupidme*

Thanks,
Martin

Posted: **Fri Dec 21, 2018 10:18 pm**

mayday!

looks like all the data of the missing months in the screenshot are gone....?!??!?!?!?!?!?!?!!?

BEfore I do something stupid, please help me:

I am saving the meteohub.backup file on a daily basis. What'S the correct way to import those properly?

Posted: **Mon Dec 24, 2018 2:25 pm**

Finally I restored the data and used my available scripts to import all the monthly csv files to SQL. Done.

meteohub.de

export whole database to csv (or other mysql readable)?

export whole database to csv (or other mysql readable)?

Re: export whole database to csv (or other mysql readable)

Re: export whole database to csv (or other mysql readable)?