Resource Type: mysql_sql

Defined in:

lib/puppet/type/mysql_sql.rb

Providers:

mysql

Overview

execute arbitrary SQL queries

Properties

• command

  The SQL command to execute via mysql.

Parameters

• cwd (defaults to: /tmp)

  The working directory under which the mysql command should be executed.

• db

  The name of the database to execute the SQL command against

• instance_name

  instance name to connect to

• mysql_path (defaults to: mysql)

  The path to mysql executable.

• name (namevar)

  An arbitrary tag for your own reference

• onlyif
• password

  password to connect

• provider

  The specific backend to use for this ‘mysql_sql` resource. You will seldom need to specify this — Puppet will usually discover the appropriate provider for your platform.

• refreshonly (defaults to: false)

  If ‘true’, then the SQL will only be executed via a notify/subscribe event.

  Supported values:

  • true
  • false
• socket

  The name of the socked to use

• unless