Need script to copy a database and all it's tables

[Robbo]

Hi,

My database contains 45 tables the structure of which is evolving as I
develop. I need a utility that will "read" the structure of this
database and it's tables and then create an identical database with
all tables.

Can you help please ?

[Robbo]

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

[Jerry Stuckle]

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.
js*******@attgl obal.net
=============== ===

[Michael Fesser]

..oO(Robbo)

>My database contains 45 tables the structure of which is evolving as I
develop. I need a utility that will "read" the structure of this
database and it's tables and then create an identical database with
all tables.

The fastest way is to do it on the command line.

Export:
mysqldump -uUsername -p -d Database tables.sql

Import:
mysql -uUsername -p Database < tables.sql

Replace Username and Database accordingly.

Micha