Re: Variable Expansion Using MySQL Client and .sql Files

2010-07-30 Thread Todd E Thomas
Simple - brilliant. I've modified to cat a temporary script... 1) cat the file as suggested: cat > ~/payload/scripts/create_mysqldb.sql << EOF ###--- ### Display the current user ###--- create database puppet; ###--- ### Display all default accounts ###--- USE puppet; ###--- ### Remove anonym

RE: Variable Expansion Using MySQL Client and .sql Files

2010-07-29 Thread Travis Ard
You could try it inside a "here" document: mysql < Date: Thu, 29 Jul 2010 14:29:55 -0500 > From: todd_...@ssiresults.com > To: mysql@lists.mysql.com > Subject: Variable Expansion Using MySQL Client and .sql Files > > Hey all, > > I've found many packag

Variable Expansion Using MySQL Client and .sql Files

2010-07-29 Thread Todd E Thomas
Hey all, I've found many packages that sit on top of MySQL for various clients. For the purposes of consistency I'd like to automate these installs. I've been directed towards using .sql files and they work great. The trouble I'm having now is that I would like to secure the installation but