Tool for exporting mySQL table structure to SQL statements

[Tore]

Is there a tool out there I can use to generate all my Tables, fields and indexes to SQL statements that I can use to generate the mySQL database that I want to use at my host.

The generation of SQL statements must work on windows98.

One more:
Can someone recommend me a tool to administer my database against my host machine on the web. I'm using win98 as the client computer. My Host provider offer a tool called phpMySQLAdmin, but I cannot use SQL statements to create, alter or drop tables, indexes or fields....

 

[KarveR]

use mysqldump, heres the manual page:

http://www.mysql.com/doc/m/y/mysqldump.html

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.