[FX.php List] Back on the trail of automating database management

[Gjermund Gusland Thorsen]

Do you have php on the FMSA itself?

I would write a php script that executes a shell script that
duplicates a template file in the server folder.

ggt667

2009/6/19 Steve Winter <steve at bluecrocodile.co.nz>:
> Hi all,
> I've floated versions of this concept up in the past, but I'm back in need
> of a way to automate the creation of a new table in 50+ instances of a
> database solution which I develop and manage for a client...
> What I want to be able to do is to create a new table, complete with field
> definitions through a script called via FX....
> This seems like something of a tall order, and to date has proved
> impossible... I looked at importing a table from a 'master' database, but FM
> won't allow the file or the table to be passed as parameters (or even set in
> globals) for the script...
> Recently I was looking at the XML import function and that looks very
> promising because I can tell the script to look for an XML file on my server
> called 'newTable.xml' (for example) and then modify that... everything along
> that line works really well except that the table ends up called 'XML import
> from http'. NOT very user-friendly...
> So, does anyone have any clue as to how I set the table name through and XML
> import...? or any other ideas on how I can go about making structural
> changes to databases using scripts...? (the desire to do this grows the more
> this solution is implemented, the more features are added, and the more I
> work with MySQL where you can define everything about the database through
> php ;-)
> Thanks for any thoughts...
> Cheers
> Steve
>
> Steve Winter
> steve at bluecrocodile.co.nz
> m: +44 77 7852 4776
> 3 Calshot Court, Channel Way
> Ocean Village, Southampton SO14 3GR
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>