APM: perl or shell script to generate MySQL db

[Evan Harris]

Mysql comes with a utility to dump and restore databases, called mysqldump.
That will probably give you what you are looking for.

Evan


On 22 Jun 2003, jeremy wrote:

> Hey Mongers,
>     I've been working on a project based heavily in MySQL/Perl DBI.
> The databases and tables in them were originally generated with the
> script I wrote early on in the project.  Since then, extensive
> modifications to the tables, and fields have made it necessary  to
> update the creation scripts.  I'd rather not update the scripts manually
> by eye-balling the table descriptions.
>
>     MY QUESTIONS ARE:
> 1a. Does anyone have a Perl script for accessing a MySQL server,
> inspecting it's databases and writing out a MySQL script for recreating
> the same databases, tables and fields?
>
> 1b. Does MySQL 4.0.13 have native support for something like this?
>
> thanks,
>    Jeremy
>
>
>
> _______________________________________________
> Austin mailing list
> Austin at mail.pm.org
> http://mail.pm.org/mailman/listinfo/austin
>