MySQL - create a dump file from DB?

Hello everybody,
Is there a way to "dump" all the tables (with columnnames and their preferences)
to a text only file?

I mean I would enter the command "mysql -u -p dump someDB > blah.txt"  (you get
the idea) and it would output something similar to the following

CREATE TABLE ie_cv_main


id INT DEFAULT '0' NOT NULL AUTO_INCREMENT,  /* Unikaalne ID    */
isikukood varchar(11),
first varchar(30),
last varchar(30),
PRIMARY KEY (id),  UNIQUE id (id));

CREATE TABLE ie_cv_stat


id INT NOT NULL,
stat_vaadatud INT,
stat_mailitud INT,
lastlog_ip varchar(30),
lastlog_time datetime DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (id));


I don't have access to the DB myself and I need a person to get me the
columnnames with everything I need to re-create the DB at another location.


Yours sincerely,
Lauri

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA