Oops,
Yea, that's pretty obvious now that you pointed it out!
Thanks
Eric
-Original Message-
From: Ken Menzel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 1:11 PM
To: George Eric R Contr AFSPC/CVYZ; mysql
Subject: Re: How to Dump only Data
Yes, the mysql proce
/CVYZ" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, October 02, 2001 2:55 PM
Subject: RE: How to Dump only Data
> I just tried this, but I get the result:
>
> mysql> SELECT * FROM ga_perf INTO OUTFILE
"/home/georgee/ga_perf.out"
rom: Ken Menzel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 11:08 AM
To: fi-claudemir; mysql
Subject: Re: How to Dump only Data
Hi Claudemir,
Perhaps you are really looking for SELECT INTO OUTFILE syntax?
http://www.mysql.com/doc/S/E/SELECT.html
Ken
- Original Message -
From
>From page 620 in MySQL...
* -t or --no-create-info
Does not write CREATE TABLE statements
Since DROPs are off by default, this should give you just the insert
statements.
The other option (as already suggested) is SELECT INTO OUTFILE.
Jay Fesco
> -Original Message-
> From: fi-claudem
Here directly from Paul Dubois's book page 619-620
mysqldump --opt db_name > backup_file
So, it would be here:
mysqldump --no-create-info db_name > backup_file
Or if you want the create statement as well, just do
mysqldump db_name > backup_file
His book is a very good one and have all you c
Didn't work... still there are informations and the INSERT INTO clause
into the dumped file
Thanks anyway!
Claudemir F. Martins
Robert Cope wrote:
>On Tue, Oct 02, 2001 at 01:55:13PM -0300, fi-claudemir wrote:
>
>>How to Dump only the data from a Table.
>>I took a look at the mysqldump option
Hi Claudemir,
Perhaps you are really looking for SELECT INTO OUTFILE syntax?
http://www.mysql.com/doc/S/E/SELECT.html
Ken
- Original Message -
From: "fi-claudemir" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, October 02, 2001 12:55 PM
Subject: How to Dump only Data