yep, your're right
thanks for clearing that up :)
How do most mysql folks sync live and development databases ?
As an alternative, I could use a PHP script on a late-night crontab.....
g
On Sep 13, 2006, at 1:11 AM, Chris wrote:
Graham Anderson wrote:
Is anyone using subversion to sync live and development databases?
If so, how?
Is this desired or a best practice?
Everything except my databases are under version control.
In theory, I would like my databases to sync with the same
subversion 'svn update' command.
That way, all web content updates with one command.
You mean schemas or the actual data?
I wouldn't do that for data - if you create a "page" in your cms on
your live system, you'd kill it off by doing an update.
Doing a schema, sure, but data - no way.
You'd need a script of some sort to handle database changes (eg
adding/removing columns/indexes), no version control system will do
this for you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
