Why is my MySQL import not possible with Ansible?

Question

I have a tutorial that should update the database from upstream. It deletes the existing database, recreates it, downloads the most recent backup copy of the product (in format .sql.gz) and tries to import it. In this last step, I get the following:

TASK [Expand: Database | Download the database from the upstream data] ***************** fatal: [54_236_190_225]: FAULT! => {"changed": false, "failed": true, "msg": "\ ngzip: stdout: Broken pipe \ n"}

Task:

- name: Database | Load the database from upstream data
  mysql_db:
    state: import
    target: /tmp/catalog-3-19-16.sql.gz
    login_host: "{{ mysql_host }}"
    login_port: "{{ mysql_port }}"
    login_user: "root"
    login_password: "{{ mysql_root_password }}"
    name: "{{ mysql_db }}"

The file /tmp/catalog-3-19-16.sql.gzexists on the server.

What am I missing?

Answer 1

, , , localhost.

 - name: Importing data
   mysql_db:
     name: "{{ db_name }}"
     login_user: root
     login_host: localhost
     login_password: "{{ mysql_root_password }}"
     config_file: no
     state: import
     target: /tmp/catalog-3-19-16.sql.gz