DMZ in a Box Don't Panic !

[Linux] Import your historical temperature data into Domogik

Here is a non-detailled tutorial on how I grabbed my old database containing my temperatures into my new Domogik installation

Domogik has a quite modular database approach, I was quite lucky as my schema was quite close to theirs.

1. Install apache2 + php5 + phpmyadmin on your domogik host

$ sudo aptitude install phpmyadmin


1. On your old host

Go to your table, Operations > Copy table to
Choose Structure + data, new table should be named `core_device_stats`

1. Check the schema used by domogik, at the time of my writing columns are as follows :

id date timestamp skey device_id value_num value_str

1. Check the device numbers used in domogik DB, table is `core_device`
2. Match your sensors ids with domogiks
3. Rename / edit your column to match domogik's schema
4. Export as CSV
5. Imports onto Domogik host

Enjoy !
If you need help, please add a comment, I'll help if the question is clear enough.

Related posts:

1. [Linux] Install Domogik from Mercurial