restore_inventory_db.yml.solution 823 B

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