restore_legacy_db.yml 781 B

12345678910111213141516171819202122232425262728293031
  1. ---
  2. - name: Restore legacy database if not present
  3. hosts: db_servers
  4. become: yes
  5. tasks:
  6. - name: Make sure legacy database exists
  7. mysql_db:
  8. name: legacy
  9. state: present
  10. register: legacy_present
  11. - name: Is legacy database backup present?
  12. stat:
  13. path: /srv/legacy-database.sql
  14. register: legacy_bkup
  15. - name: Copy database backup file to host if not present
  16. copy:
  17. src: files/legacy-database.sql
  18. dest: /srv
  19. when:
  20. - legacy_present['changed'] == true
  21. - legacy_bkup['stat']['exists'] == false
  22. - name: Restore legacy backup data
  23. mysql_db:
  24. name: legacy
  25. state: import
  26. target: /srv/legacy-database.sql
  27. when: legacy_present['changed'] == true