Important: If you have applied any custom Chef recipes for MySQL, disable them in your ey-cloud-recipes repository. You may re-apply them to your new database instance after completing the tasks on this page. For general information about custom Chef recipes, see Custom Chef recipes.
Create a new application with a new environment or add an environment to an existing application, making sure to:
Set the Database Stack to MySQL 5.1.x. If this option is not available, see Troubleshooting.
Add the mysql2 gem to your Gemfile for Rails 3 (or via the dashboard for Rails 2).
source "http://rubygems.org" gem "mysql2"
Select SSH Keys. This allows you to SSH into the new instance and to copy the database dumpfile to the instance, described in the procedure below.
Deploy the application.
Dump and restore an existing MySQL database
If you are currently running a MySQL database (5.0.x), you need to dump the database, create a new MySQL environment, move the database dump file to the database instance, and finally load the file into the MySQL database.