Re: MySQL - create a dump file from DB?

----- Original Message -----
From: Lauri V�in <optima(at)hot.ee>
To: <hwg-languages(at)hwg.org>
Sent: Wednesday, November 08, 2000 2:59 PM
Subject: 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

mysqldump -p --add-drop-table DATABASENAME > blah.sql

blah.sql can be edited in any text editor






> 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