[BUG] MySQL database backup does not include procedures

[yassinedoghri]

Describe the bug

MySQL database backup does not include procedures.

Context

Castopod uses stored procedures for podcast analytics. If the procedures are not present, the analytics will not store hits and the feature will not work anymore.

Steps to reproduce

• Perform a backup of Castopod
• Restore the backup --> All tables and data are restored but no more procedures

Expected behavior

The backup should restore routines with the tables and data.

---

Looking at the backup script, the ynh_mysql_dump_db helper does not include the needed --routines flag to make this work:

• https://github.com/YunoHost-Apps/castopod_ynh/blob/5dcfa414c5958a0e706f5b99858b48e36a057fd8/scripts/backup#L65
• https://github.com/YunoHost/yunohost/blob/394907ff0df218ec926f43c2e2ba006c68cc3f8a/helpers/mysql#L128

[ericgaspar]

Thanks for pointing this out! ynh_mysql_dump_db helper should be updated when the next YunoHost version is out.