No database is complete simply by installing the software and configuring it—often, there is a very important intermediate stage, which involves loading an initial dataset. This might be a backup from a previous database, a sanitized dataset for testing purposes, or, simply, a schema into which application data can be loaded.
Although Ansible has modules for a limited set of database functions, the functionality here is not as complete as that for other automation tasks. The most complete support offered for a database by Ansible is for PostgreSQL—with lesser support for some other databases. Through some clever use of the shell module, any manual task that you can perform on the command line can be replicated into an Ansible task. It is up to you to apply logic to the tasks to handle errors or conditions where, for example, a database...
