Change Database Name


#1

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.


#2

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


#3

Matt H. 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.