Did you check out the -w option to mysqldump?
andy wrote:
>Hi there,
>
>I am trying to get only records out of a table mathing a query. This should
>be piped into a textfile. My problem is that I have to transmit this records
>to a new machine. So the output should be a kind of sql commands which I
>could run with phpadmin or similar to import them to the other db on the
>other machine.
>
>Is this possible?
>
>Thank you for any help,
>
>andy
>
>
>---------------------------------------------------------------------
>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 <mysql-thread110932@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
