mysql 5 -- generate database script

[David Bandel]

On 12/21/05, Man-wai CHANG <mwchang at i-cable.com> wrote:
> Which tool could read the database and table definitions in mysql 5 and
> generate a database-generation script? Something like what the
> enterprise manager M$$SQL does.

Don't know on mysql (although I assume mysql is like postgres here),
but any postgres backup script (which uses the postgres utilities, so
you could do this directly) allows you to save the schema (with
headers to allow a complete reinstall of the database or only recreate
the database) or data only or data and schema. I?l be even webmin
would do this for you.  Or check out phpmyadmin or some such.

In fact, this is a very common task for a DBA, so I suggest RTFM
first, and if not then a check of freshmeat.  M$ didn't create
anything new, they bought the Sybase engine, looked at the available
GUI interfaces and made one that's worse than any other (more
complicated, less intuitive, less capable).

Ciao,

David A. Bandel
--
Focus on the dream, not the competition.
            - Nemesis Air Racing Team motto