>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-claudemir [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 02, 2001 12:55 PM > To: mysql > Subject: How to Dump only Data > > > Hi > > How to Dump only the data from a Table. > I took a look at the mysqldump options, but I didn't find something that > works fine ! > > Regards > Claudemir F. Martins > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php