Ansible playbook to copy database dump file to remote host and restore it to another database

Question

I was wondering if anybody could help me out in writing a playbook for copying database dump file to a remote host and restore it to another database. Thanks in advance.

Answer 1

Hey @Pavan, you can use the following task for your playbook:

- name: Copy database dump file
  copy:
    src: dump.sql.bz2
    dest: /tmp
- name: Restore database
  mysql_db:
    name: my_db
    state: import
    target: /tmp/dump.sql.bz2

There are two tasks, one for transferring data to the remote and the other for restoring.