CCIE那点事

https://www.kancloud.cn/hiyang/ansiblebook/306176

mysql_db模块用于建立、删除、导入和导出数据库

建立数据库

state="present"

---
- name: mysql
  hosts: s.hi.com
  tasks:
  - name: create a database
    mysql_db:
      login_host: "127.0.0.1"
      login_user: "root"
      login_password: "mysql@123"
      login_port: "3306"
      name: "mezz"
      encoding: "utf8"
      state: "present"

删除数据库

state="absent"

---
- name: mysql
  hosts: s.hi.com
  tasks:
  - name: delete a database
    mysql_db:
      login_host: "127.0.0.1"
      login_user: "root"
      login_password: "mysql@123"
      login_port: "3306"
      name: "mezz"
      state: "absent"

导出数据库

state="dump"

---
- name: mysql
  hosts: s.hi.com
  tasks:
  - name: dump a database
    mysql_db:
      login_host: "127.0.0.1"
      login_user: "root"
      login_password: "mysql@123"
      login_port: "3306"
      name: "mezz"
      target: "/tmp/mezz.gz"
      state: "dump"

导入数据库

state="import"

---
- name: mysql
  hosts: s.hi.com
  tasks:
  - name: import a database
    mysql_db:
      login_host: "127.0.0.1"
      login_user: "root"
      login_password: "mysql@123"
      login_port: "3306"
      name: "mezz"
      target: "/tmp/mezz.gz"
      state: "import"