Rails application deployed and working, but MySQL database appears empty

Question

I've deployed a Ruby on Rails application using mod_rails and nginx over Capistrano, and it's working perfectly, but I have a baffling problem.

When I run the following command on the server:

SHOW TABLES IN application_production;

MySQL returns:

Empty set (0.00 sec)

I know that information is being written to the database because I've entered data that is being saved. I've tried restarting the Rails application and the entire server, as well as accessing the site from other computers, and it's working perfectly, yet the query is still returning an empty set. I'm completely stumped.

Anyone have any idea what's going on? Thanks!

Answer 1

Of course, 10 minutes after I post the question I figure it out:

I hadn't committed my updated database.yml file to Mercurial before I deployed, so when it pulled down the latest changeset, the old database.yml (with the default production database) was used. Because of this, it was using an SQLite database in my project folder instead of MySQL.

Stupid mistake! Moral: ALWAYS make sure you commit before you deploy.

Answer 2

Was your database.yml file set up correctly for the production environment?