RE: changes in tables (developemnt -> production)

2007-09-07 Thread Power, Paul C.
. Make sure the new code works. Now I can run the upgrade SQL on the production box. > -Original Message- > From: Edward Kay [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 06, 2007 7:24 AM > To: Afan Pasalic; mysql@lists.mysql.com > Subject: RE: changes in tabl

RE: changes in tables (developemnt -> production)

2007-09-06 Thread Edward Kay
> what steps do you recommend to do the tables update on the production > database? When I work on our site DB, I follow the following steps: 1. Trash the existing dev DB and replace with the current live version 2. Develop! 3. Dump all the tables I have changed (structure and/or data) using mys