Sr. Web Developer
mediabistro.com
US-NY-New York

Justtechjobs.com Post A Job | Post A Resume

Comments for: tim19990915

Message # 1011271:
Date: 05/11/02 15:50
By: Patrick
Subject: RE: How to deal with Database driven sites ?

1. Take a sql snapshot (eg mysql dump) of your DB (structure only).
2. Commit this to CVS.
3. Tag the cvs module - ie declare a version which maps to this DB schema.
4. Perform all new DB schema changes as SQL scripts, and commit those scripts to CVS.
5. Whenever you tag a version of your module add a new, full sql schema dump.

What do you think?

Previous Message | Next Message


Comments:
RE: CVS via PHPPierre02/08/05 05:28
CVS via PHPArthur McLean01/11/05 13:26
use cvs export, .htaccessisao09/18/03 12:09
Adding files with cvs commitJ. Germano09/18/02 15:29
rsync and sshkastar08/27/02 05:49
why not use CVS export?Carl Meyer06/26/02 11:31
cvs quick guide in Chinesechedong05/24/02 03:05
RE: How to deal with Database driven sites ?Patrick05/11/02 15:50
custom 404 error page for NTMichael Sculley04/23/02 14:32
remove revision number clutter from diffsRoger Collins03/08/02 17:08
different between server and clientdaddius01/04/02 15:09
RE: GUI version for windown based clients??rasmus12/20/01 17:14
GUI version for windown based clients??DotGlum12/10/01 08:07
Error Noticing!!!Steven Chalker11/24/01 10:09
RE: NT hosted sitesneiljmac08/23/01 16:07
Explorer interfaceFrancis Irving07/13/01 03:03
using ssh and cvsdave07/10/01 09:36
RE: Don't clean up CVS dirsMax Hammond06/03/01 13:34
CVS is a exelent solution for any projectNeuromancer05/29/01 08:36
CVSwebAndy Wismar05/24/01 08:27
RE: CVS is excellent - proofOktay Altunergil04/02/01 17:31
RE: CVS is excellent - proofEffendi03/05/01 04:40
Don't clean up CVS dirsThierry de Villeneuve03/04/01 23:58
CVS is excellent - proofDave Kingdon02/21/01 18:40
Remote CVS repositoryZach02/11/01 08:58
RE: Better solution than pserver for web projBarnaby02/06/01 09:25
ExportDavid Buchan02/03/01 15:03
RE: client interfaceCloudmaster01/30/01 18:36
RE: NT hosted sitesSean01/05/01 10:25
RE: client interfacejoey01/02/01 14:05
NT hosted sitesChris Hemming12/28/00 15:16
How to deal with Database driven sites ?Xavier12/05/00 10:24
RE: Better solution than pserver for web projectsAlaric Snell11/22/00 19:07
Better solution than pserver for web projectsJason08/24/00 00:37
RE: client interfaceChris Stephens07/12/00 03:08
client interfacejohnny brasseur06/29/00 03:39
 

If you are looking for help, please post on the appropriate forum here. Your questions will be answered much more quickly.

Add A Comment:

Name:

Email:

Subject:

Message:

To reduce spam posts, messages are now manually approved

You are not [logged in]. That means your account will not get credit for this post.