Change Database Name

Hi,

I'd like to change the name of the database for an app I have in production (the current name is too ambiguous). As I see it I will need to change the database.yml file and the database name in mysql. Is there anything else? A better way? Suggestions?

I want to be on the cautious side, for obvious reasons.

Thanks.

Dan Weaver wrote:

Hi,

I'd like to change the name of the database for an app I have in production (the current name is too ambiguous). As I see it I will need to change the database.yml file and the database name in mysql. Is there anything else? A better way? Suggestions?

I want to be on the cautious side, for obvious reasons.

Thanks.

You could copy the database to the new name, and then change database.yml.

Then you can delete the original database without any downtime.

HTH

Matt

Matt Harrison wrote:

You could copy the database to the new name, and then change database.yml.

Then you can delete the original database without any downtime.

HTH

Matt

Good suggestion, thank you.