How do I keep the development MySQL schema in synch with the live one?

This for me sounds that you need to establish a ground source of truth, not only for changes to the DB schema but for all the other things too. Ideally you can build up a new environment from all the ground sources of truth and it will match the current state of the production environment.

For an SQL schema, I would propose that all modifications to the schema go through SQL text files which are kept under source control and applied one by one. For example App::sqitch purports to do that, but you can also do it manually or with a script of your own.

If you can keep to moving all changes to your production environment through text files source control, you can basically replay and replicate the environment everywhere where you can replicate your source control to.

In reply to Re: What is a good, straightforward Perl with Mysql development environment? by Corion
in thread What is a good, straightforward Perl with Mysql development environment? by jfrm

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.