Solved: MySQL Database Backup with Ansible

sonu_2311 · ‎03-09-2022

Hi Team,

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

magnuz · ‎03-09-2022

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,

magnuz · ‎03-09-2022

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 · ‎03-10-2022

Thanks. Its worked.

MySQL Database Backup with Ansible