NYCPHP Meetup

[Ben Sgro (ProjectSkyline)]

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" <support at dailytechnology.net>
To: "NYPHP Talk" <talk at lists.nyphp.org>
Sent: Tuesday, March 27, 2007 8:05 AM
Subject: Re: [nycphp-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