[mysql_db模塊][1]用于建立、刪除、導入和導出數據庫 #### 建立數據庫 `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" ``` [1]:http://docs.ansible.com/ansible/latest/mysql_db_module.html