Prepare Database Access

Your Brightbox comes with access to a shared MYSQL database cluster. The migration recipes check the format of database.yml for the environment you are deploying to and will warn you if there is information missing, or in the wrong format

Edit the database.yml file

Edit your database.yml and alter the production section to the following:

  production:
    adapter: mysql
    host: sqlreadwrite.brightbox.net
    username: <your database user name>
    password: <your database password>
    database: <your database user name>_<your application name>_<configuration section>

You'll find the database username and password on the Brightbox control panel

The 'application name' is a short name for your application that differentiates this application database from all the others stored under your Mysql username.

So, for example, if you have a database user name of fred and an application called myforum then your production section would look like this.

  production:
    host: sqlreadwrite.brightbox.net
    username: fred
    password: a_password
    database: fred_myforum_production

Back to Index

docs/gemv2/howto/database.txt · Last modified: 10 Jun 2008 @ 10:09 am by neilw