[nycphp-talk] Creating database tables when deploying products
Brian Dailey
support at dailytechnology.net
Tue Mar 27 08:05:05 EDT 2007
If you are deploying databases across multiple systems on a regular
basis (ie: planning on doing it more than once or twice) I recommend you
look into the PHP version of Ant called Phing.
http://phing.info/trac/
Jiju Thomas Mathew wrote:
>
>
>
> So my question is ... is what I'm doing ok? .. there must be a
> better way to do it ... How are you all
> doing database table creation for products that need to be deployed
> on multiple systems.?
>
>
>
> We use a more or less the same method, with one difference, that is the
> sql query instead of being embedded, is a seperate setup.sql file with
> comments and whitespace stripped off. Means, each complete statement is
> in one line. The script issues a source setup.sql to the mysql after
> connecting to the database.
>
> --
> Jiju Thomas Mathew
> http://www.php-trivandrum.org
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
More information about the talk
mailing list