Posted by Jerry Stuckle on 07/10/07 14:48

Robbo wrote:
> Thanks for all your input. Perhaps I should have been more specific in
> the question -
>
> I need re-useable php code to get the structure of a MySql database
> and it's tables then to create a new EMPTY MySql database with the
> same structure.
>
> All help appreciated
>

Robbo,

OK, that's a different story.

You're probably better off using the MySQL calls to get your information
- such as SHOW TABLES to get the table list, SHOW CREATE TABLES to get
the CREATE TABLE statement used, etc.

You can go to comp.databases.mysql for the MySQL statements you need.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]