Copying a remote MySQL Database

Archives Ansible Project
1

I am wondering if anyone has copied a MySQL database from a location and then restored it locally using Ansible? I thought I had it figured out with the following syntax, but for some reason its failing.

`

  • name: Install python-mysqldb
    apt: name=python-mysqldb state=latest

  • name: Copy MySQL Database
    mysql_db: login_host=onthe.web.net login_user=someone login_password=cheese state=dump name=cheese target=/tmp/cheese.sql
    mysql_db: state=import name=cheese target=/tmp/cheese.sql
    `

Any help would be appreciated.

Steven

2

split ‘Copy MySQL Database’ into two separate tasks, with one action each.

3

Awesome that worked, thanks for the help.

Steven