# - name: add 'mysql' to path
#   lineinfile:
#     dest: /etc/paths
#     state: present
#     backrefs: yes
#     regexp: 'PATH=(["]*)((?!.*?/usr/local/mysql/bin/).*?)(["]*)$'
#     line: 'PATH=12:/usr/local/mysql/bin3'

# - name: add 'mysql' to path
#   shell: export PATH=$PATH:/usr/local/mysql/bin && echo $PATH

- name: Copy database dump file to host
  copy:
    src: bd_demo_dump.sql
    dest: /tmp

- name: Restore database
  mysql_db:
    login_user: root
    login_password: password
    state: import
    name: all
    target: /tmp/bd_demo_dump.sql