MySQL - create a dump file from DB?

by =?iso-8859-4?B?TGF1cmkgVuRpbg==?= <optima(at)hot.ee>

 Date:  Wed, 8 Nov 2000 22:59:31 +0200
 To:  <hwg-languages(at)hwg.org>
  todo: View Thread, Original
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