Re: anyone using subversion to sync mysql dbs ?

2006-09-13 Thread Chris
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

Re: anyone using subversion to sync mysql dbs ?

2006-09-13 Thread Dan Buettner
For our Ruby on Rails app, during development, we're using SVN to store and sync a group of SQL load files, containing all the delete, insert and update commands necessary to fully populate the database. After doing an SVN update we then run a shell (or batch) script to pipe the SQL files into

Re: anyone using subversion to sync mysql dbs ?

2006-09-13 Thread Graham Anderson
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

Re: anyone using subversion to sync mysql dbs ?

2006-09-13 Thread Chris Sansom
No, I don't generally go along with underhand political activity. :-) (but I expect that's an old joke - I haven't been MySQLing all that long, you see...) -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Any inaccuracies in this index may be explained by the fact

anyone using subversion to sync mysql dbs ?

2006-09-12 Thread Graham Anderson
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