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
_______________________________________________
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
