Question

How to create MySQL tables using Ansible?

Answer 1

Hey @Anvit, you can use a module called mysql_db to add or remove databases from a remote host.

And then you can just copy all the create statement into a single file and import it. 

something like this:

- mysql_db: name=my_db state=import target=/tmp/dump.sql.bz

Answer 2

---

- hosts: dbserver

  tasks:

   - name: create a table in mysqlDB

     command: mysql -u username -p yourpassword -h yourhostname dbname --skip-column-names --execute "create table if not exist tablename (name INT AUTO_INCREMENT, title VARCHAR(255) NOT NULL"

Comments

Thanks @Ankit

---

M using same command :

    command: mysql -u root -p ********** bobdata --skip-column-names --execute "create table test789 (Name VARCHAR(25),ID int)"

But its giving syntax error . Kindly assist.

---

Hey @Shubhi, "int" should be in caps. Change the command to the following:

mysql -u root -p ********** bobdata --skip-column-names --execute "create table test789 (Name VARCHAR(25),ID INT)"