[Phpwm] MySQL DB/Table Sync (Maakit)

[Pete Graham]

Hi Richard,

Thanks for your suggestion, I'd considered this option, it's a ZF
project so I'd have to look into how to update the applicaton.ini file
to use the new DSN on publish.

I think I'm going to go with the Maakits solution, I was having a play
about with it yesterday and it seems like a really good set of mysql
power tools. It has a nice option where you can get it to print the
sync sql rather then execute it which is useful to see what it's
doing.

Pete

On 15 June 2010 20:03, Richard Wallman <richard at wallman.org.uk> wrote:
> On Tue, Jun 15, 2010 at 05:07:19PM +0100, Pete Graham wrote:
>> I'm open to alternative solutions to this issue if anyone has them.
>
> How about dumping the preview DB into a different schema, then getting
> the "Go Live!" script to change the DSN to use the new schema name after
> the code is uploaded.
>
> No downtime, and you've got the old DB still around in case you
> want/need to rollback.
>
> --
> Richard Wallman
>
> _______________________________________________
> Phpwm mailing list
> Website : http://www.phpwm.org
> Twitter : http://www.twitter.com/phpwm
> Facebook: http://www.facebook.com/group.php?gid=2361609907
>
> Post to list: Phpwm at mailman.lug.org.uk
> Archive etc : https://mailman.lug.org.uk/mailman/listinfo/phpwm
>