MySQL Database Backup with Ansible

[sonu_2311]

Hi Team,

Please any one can guide me how to take the MySQL Database backup using Ansible.

[magnuz · Accepted solution]

Hi @sonu_2311 ,

You can perform a dump using the mysql_db module. To perform a dump of a mysql db called db1:

- name: Dump database db1
  mysql_db:
    state: dump
    name: db1
    target: /tmp/dump.sql

For further details please visit the Ansible documentation of this module.

Regards,

[sonu_2311]

Thanks. Its worked.