Revert "Introduce role::mariadb::backup"

Reverting because needed class passwords::mysql::dump has not yet been
added in the private repo.

This reverts commit 0cdadcd1535862a909ba14e48e7b45716e0b5365.

Change-Id: Ib1ad7b103cde05d7770576ff26b6841b77639173