Jay Blanchard wrote:
>[snip]
>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?
>
>
How about:
echo <your_statement_here> | mysql -N <database> | ssh
<user>@<remotemachine> 'cat - | mysql -N <database>'
assuming you are using kind of Unix/Linux with abilitiy to contact the
remote machine with ssh
Greetings
Ralf
>
>
---------------------------------------------------------------------
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