mysql_db – Add or remove MySQL databases from a remote host

• Synopsis
• Requirements
• Parameters
• Notes
• Examples
• Status

Synopsis

• Add or remove MySQL databases from a remote host.

Requirements

The below requirements are needed on the host that executes this module.

• MySQLdb (Python 2.x)
• PyMySQL (Python 2.7 and Python 3.X), or
• mysql (command line binary)
• mysqldump (command line binary)

Parameters

Notes

Examples

- name: Create a new database with name 'bobdata'
  mysql_db:
    name: bobdata
    state: present

# Copy database dump file to remote host and restore it to database 'my_db'
- name: Copy database dump file
  copy:
    src: dump.sql.bz2
    dest: /tmp
- name: Restore database
  mysql_db:
    name: my_db
    state: import
    target: /tmp/dump.sql.bz2

- name: Dump all databases to hostname.sql
  mysql_db:
    state: dump
    name: all
    target: /tmp/{{ inventory_hostname }}.sql

- name: Import file.sql similar to mysql -u <username> -p <password> < hostname.sql
  mysql_db:
    state: import
    name: all
    target: /tmp/{{ inventory_hostname }}.sql

Status

• This module is not guaranteed to have a backwards compatible interface. [preview]
• This module is maintained by the Ansible Community. [community]

Authors

• Ansible Core Team