When you run rancher/server with a bind-mounted directory, both processes (MySQL and cattle) are always running so it can be hard to restore a backup.
Creating a backup can be done using:
docker exec rancher_server_id mysqldump --default-character-set=utf8 --databases cattle > cattle.sql
This will save the database called cattle (default) to cattle.sql on the host.