[Q] HA doesnt seem to be using MySQL recorder

Configuration
1

used this great little guide:

recorder.yaml (included in configuration.yaml)

db_url: mysql://hass:mypassword@localhost/hass_daz
purge_keep_days: 2
purge_interval: 1
#include:
#  entities:
#    - sensor.smithville_cloud_coverage
#    - binary_sensor.laundry_motion_opened
exclude:
  domains:
    - updater
    - camera
    - media_player
    - sun
    - zone
    - group
    - sensor
    - binary_sensor
    - automation
    - calendar
  entities:
    - weather.home

then I issued the service call recorder.purge (with repack: true)

home-assistant.log

2020-04-21 23:07:26 DEBUG (Recorder) [homeassistant.components.recorder.purge] Purging events before 2020-04-11 22:07:26.205792+00:00
2020-04-21 23:07:26 DEBUG (Recorder) [homeassistant.components.recorder.purge] Deleted 0 states
2020-04-21 23:07:26 DEBUG (Recorder) [homeassistant.components.recorder.purge] Deleted 0 events
2020-04-21 23:07:26 DEBUG (Recorder) [homeassistant.components.recorder.purge] Vacuuming SQL DB to free space

but there are not tables in the hass_daz db?

MariaDB [hass_daz]> connect hass_daz;
Connection id:    73
Current database: hass_daz

MariaDB [hass_daz]> show tables;
Empty set (0.001 sec)

MariaDB [hass_daz]> show databases;
+--------------------+
| Database           |
+--------------------+
| hass_daz           |
| information_schema |
+--------------------+
2 rows in set (0.001 sec)

???

2

try :

db_url: mysql://hass:mypassword@localhost/hass_daz?charset=utf8
3

thanks, but still got empty database (no tables) in hass_daz. Connection is fine from the xterm command line and - as OP - I can see the the system db and hass_daz - but the latter is empty (i.e. show tables; gives nothing - empty db)

4

Never mind.
Gone back to sqllite or whatever it uses.
Too much hassle, got plenty of other jobs round house to crack on with.