mysql_db - Add or remove MySQL databases from a remote host.

• Synopsis
  • Requirements
• Parameters
• Notes
• Examples
• Status
• Maintenance
  • Author

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 flagged as preview which means that it is not guaranteed to have a backwards compatible interface.

Maintenance

This module is flagged as community which means that it is maintained by the Ansible Community. See Module Maintenance & Support for more info.

For a list of other modules that are also maintained by the Ansible Community, see here.

Author

• Ansible Core Team