Home-assistant.db 30Gbyte in one day, what to do?

[anon35356645]

well I followed instructions and moved to mysql too

I did this

Large homeassistant database files

Hi All, Seemed to get this installed without too many issues on a HASSBIAN image. Only been running for approx 10 mins so far though. Details below: Complete the following outside the venv: sudo apt-get install libmysqlclient-dev sudo apt-get install python-dev python3-dev sudo apt-get install mysql-server ** create root password when prompted ** mysql -u root -p ** enter root password ** CREATE DATABASE hass_db; CREATE USER 'hassuser'@'localhost' IDENTIFIED BY 'XXX'; <-------XX…

Add the following to your configuration.yaml file:
recorder:
db_url: mysql://hassuser:[email protected]/db_name?charset=utf8