title: CloudFormation : Template RDS Mysql to Create DB, Tables, User, or Load Schema
body: <p>Using CloudFormation, I'm trying to figure out a few use cases. </p>
  
  <p>The first case is having an existing AWS RDS MySQL server, how to create a database, tables, and a user account though a CloudFormation template.</p>
  
  <p>After looking at the Cloudformation docs, I thought there could be a
  <code>AWS::RDS::DBInstance</code> property that would allow me to do this action; however, though I couldn't find how to specify a database host source (or I may have misread it) that would allow.</p>
  
  <p><code>aws-properties-rds-database-instance</code></p>
  
  <p>then, looking at the Cloudformation RDS templates from AWS, I saw an <code>fn::join</code> command that stood out. Would my first case be done with <code>fn::join</code>?</p>
  
  <pre><code>"UserData": { "Fn::Base64": { "Fn::Join": ["", [....
  </code></pre>
  
  <p>Next, in the second case, I'm also having trouble finding how using an existing RDS MySQL server, load a scheme from a MySQL mysqldump.</p>
  
  <p>I've looked at the docs in the link above for answers but not quite sure.  I noticed AWS templates mostly allow you to create resources.</p>
  
  <p>Lastly, to solve the above two cases, I've also been reading that it could or should(?) be done using  a two tool approach by way of using an AWS CloudFormation template and calls to Chef.</p>
  
  <p>Thoughts?</p>