Re: [GENERAL] Replacing a production db

2014-06-18 Thread Andy Colson
On 6/18/2014 3:05 PM, Nicolás Lichtmaier wrote: Is there a way to replace a production database with another as part of a new "release" of our website? Where I work we have a scheme of pushing code+db releases to "testing" and then to "production". Most of our databases use MySQL and I was told

Re: [GENERAL] Replacing a production db

2014-06-18 Thread John R Pierce
On 6/18/2014 1:05 PM, Nicolás Lichtmaier wrote: Is there a way to replace a production database with another as part of a new "release" of our website? Where I work we have a scheme of pushing code+db releases to "testing" and then to "production". Most of our databases use MySQL and I was to

Re: [GENERAL] Replacing a production db

2014-06-18 Thread Tim Clarke
On 18/06/14 21:50, Nicolás Lichtmaier wrote: > I'm probably doing this wrong, but I couldn't find any resources to > learn how to get this right. > > Can the renaming be done without disruption to current connections? > From what I've read you have to disconnect everyone before renaming a > databas

Re: [GENERAL] Replacing a production db

2014-06-18 Thread Nicolás Lichtmaier
I'm probably doing this wrong, but I couldn't find any resources to learn how to get this right. Can the renaming be done without disruption to current connections? From what I've read you have to disconnect everyone before renaming a database. 2014-06-18 17:47 GMT-03:00 Bill Moran : > On Wed,

Re: [GENERAL] Replacing a production db

2014-06-18 Thread Bill Moran
On Wed, 18 Jun 2014 17:05:22 -0300 Nicolás Lichtmaier wrote: > Is there a way to replace a production database with another as part of a > new "release" of our website? > > Where I work we have a scheme of pushing code+db releases to "testing" and > then to "production". Most of our databases u

Re: [GENERAL] Replacing a production db

2014-06-18 Thread Andrew Sullivan
On Wed, Jun 18, 2014 at 05:05:22PM -0300, Nicolás Lichtmaier wrote: > Where I work we have a scheme of pushing code+db releases to "testing" and > then to "production". Most of our databases use MySQL and I was told they > can just rename the db and it works. We are adopting PostgreSQL for some >

[GENERAL] Replacing a production db

2014-06-18 Thread Nicolás Lichtmaier
Is there a way to replace a production database with another as part of a new "release" of our website? Where I work we have a scheme of pushing code+db releases to "testing" and then to "production". Most of our databases use MySQL and I was told they can just rename the db and it works. We are a