What Rails deployment tools do you use for DB management?

When it comes to deployment in Rails, the one and only tool that comes to mind is Capistrano. No doubt that is the only tool that helps with deploying source code updates to your production server/s. By the way, don’t you just love the Capistrano logo Anyway, back to what I was trying to talk about – what about tools for DB management. I’m sure some people would have came across a situation where they have huge set of tables that are non-user related data, maybe such as information of all the hotels in the US, say … if you building a hotel search engine. How are you doing DB migration then for the data?

The only way and the way that I’m doing right now with our MySQL db is using

mysqldump with several options ..

and then scp onto the production DB server. And then

mysql -u root -p your_db < backup.sql

I’m sure if you are a linux shell script geek, you would have already written up a script to do the backups of your DB in an orderly manner. But not everyone is that geeky. So as Capistrano gets better with 2.0, maybe it’s time to think about incorporating better DB data and backup management into Capistrano. What do you think? Would you buy that? Or perhaps there is already a good tool out there for doing this, if so please drop a note. Thanks!