mysql 5 -- generate database script

[Federico Voges]

David Bandel wrote:
> 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).
>   
mysqldump should do it ;)

-- 
Federico Voges.

Running: Mac OS X 10.4.3 (build 8F46)
Kernel:  8.3.0 Power Macintosh
Procesor: PowerPC G4 @ 1.67GHz
Uptime:  12:48  up 3 days, 22:13, 3 users, load averages: 0.15 0.08 0.09


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.linux-sxs.org/pipermail/linux-users/attachments/20051221/6d43a5f8/attachment.htm