I was wondering how people go about pushing code changes to a live site. Currently I:
1 Test the changes on my local staging version of the site
2 Uploaded the changed files
3 Quickly rebuild the database once the uploads are complete
4 Hope nothing's gone screwy!
5 Then manually perform any CMS actions to use the changes, such as new pages etc
Is this how others do it?
Is there a better way? Avoid users accessing the site before the database has rebuilt?
Do you lock the site during updates? If so how?
Interested to hear how everyone does it.