NYCPHP Meetup

NYPHP.org

[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