Re: MySQL - create a dump file from DB?
by "Karin Ransdell" <kransdell(at)squishedmosquito.com>
|
Date: |
Wed, 8 Nov 2000 16:01:55 -0600 |
To: |
"Lauri V�in" <optima(at)hot.ee>, <hwg-languages(at)hwg.org> |
References: |
koll |
|
todo: View
Thread,
Original
|
|
----- 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