Posted by J.O. Aho on 01/15/07 15:32

Lorenzo Bettini wrote:
> J.O. Aho wrote:
>> Lorenzo Bettini wrote:
>>
>>> OK, I need a php framework that reads the structure of a mysql table
>>> and generates php code that can recreate that table in another mysql
>>> database.
>>
>> What about using mysqldump?
>>
>
> I know that too, but I'd like then to be able to recreate the table from
> php; do you actually suggest to load from php that file and using a
> mysql_xxx command to recreate the table?

Yes, php calls mysqldump and creates you a sql file, which you can then upload
to your other database and use mysqldump to inject it.


> I'd like to have a finer grain control: e.g., being able to have all the
> structure fields, but create only on field...

You can process the mysqldump output and remove things you don't want to transfer.


--

//Aho

[Back to original message]