Production Migration

Hi

I’ve deployed my app to production running mysql 5.1.49-1ubuntu8.1

When running rake db:migrate RAILS_ENV=production

I get the following output with no errors and nothing in the
production.log

(in /home/ubuntu/apps/myapp/releases/20110203151404)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
** Invoke db:schema:dump (first_time)
** Invoke environment
** Execute db:schema:dump

rake db:create RAILS_ENV=production created the database fine. I noticed
after running the migration my schema.rb has been reverted to migration
0

If anyone has any pointers on where to look or even if its config issue
somewhere

Thanks
Nath

ruby 1.9.2p136 (2010-12-25 revision 30365) [i686-linux]
rails 3.0.3

GEMS
gem ‘rails’, ‘3.0.3’
gem ‘nifty-generators’
gem ‘thinking-sphinx’
gem ‘hpricot’
gem “will_paginate”, “~> 3.0.pre2”
gem “RedCloth”
gem ‘mysql2’
gem ‘jquery-rails’
gem ‘delayed_job’,:git =>
‘git://github.com/collectiveidea/delayed_job.git’
gem ‘slim_scrooge’

DB.yml

production:
adapter: mysql2
database: des
username: root
password:
host: localhost

try

cap deploy:migrations

instead of cap deploy