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 can dream and more.

I hope we will be lucky to get a revise copy for the 4.0, but I am sure this
is hell to do.

Hope this answer your question.

Daniel


> -----Original Message-----
> From: fi-claudemir [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 02, 2001 12:55
> 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

Reply via email to