Hello all,
Brian - Looks cool, but seems like I need CL access to the host ..which I
often do not have.
I'll look into it more.
Jiju - So you use an .sql file w/the instructions to build the table. Do you
execute from CL, PHP or
phpMyAdmin. As stated above, I often do not have CL access to a host.
Thanks for your suggestions.
- Ben
----- Original Message -----
From: "Brian Dailey" <[EMAIL PROTECTED]>
To: "NYPHP Talk" <[email protected]>
Sent: Tuesday, March 27, 2007 8:05 AM
Subject: Re: [nyphp-talk] Creating database tables when deploying products
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
_______________________________________________
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
