generate database script from existing table?

[Chiah Tong Kiat]

Hi

I just took over a mysql database with no documenation.  Is there any
tools or anyway I could generate a database/table creation script from
the current database?  This is because I need to recreate the database
on another machine and currently I have no way of doing so.

thanks
tk