Hi,
I’m trying to import DB to MySQL via Ansible.
For test, I cloned test_db from https://github.com/datacharmer/test_db.git and placed it to /test_db
Than I run the following:
mysql_db:
login_user: root
login_password: “{{ password }}”
state: import
name: all
target: /test_db/employees.sql
and failed with - “Failed to open file ‘load_departments.dump’”
This file presented in /test_db and I just need to chdir to this folder, but there is no such option in mysql_db module.
I know that I can do it successfully with command module, but is there any way to do it with the dedicated one?