mysql

This is the mysql module.

Definition: mysql::do

#

connect to a mysql host and run specified sql code

#

Parameters:

$host - hostname, uses localhost by default

$port - port number, uses 3306 by default

$content - specify content or a template instead of a .sql file

$source - .sql file to load

$user - mysql username, uses root by default

$password - mysql password uses blank by default

$database - name of mysql database

#

Actions:

connects to a mysql host and load sql code

#

Requires:

must specify at least $source or $content

#

Sample Usage:

setup database

mysql::do {

"openfire_db_create":

source => "puppet:///modules/openfire/openfire.sql";

"openfire_db_setup":

require => Mysql::Do["openfire_db_create"],

database => "$openfireDB",

source => "puppet:///modules/openfire/openfire_mysql.sql";

} # mysql::do