If you run an application that includes a database, you want to be taking backups regularly. Your backup needs to include tables, views and triggers. It must also include any stored procedures / routines you are using. Otherwise, when you restore from backup, your procedures will be missing.
This article is not about Microsoft SQL Server. This concerns MySQL and its forks MariaDB and Percona.
I've found lots of people asking this question on the web, but not many of the posts I've found have a working answer.