Lawrence Blades writes:
> A newbie question:
>
> Is it possible to use SELECT...OUTFILE and have it redirected to another
> host?
> I don't see any options in the doc., nor in the archives.
>
> My mysql server is located on a different machine than my WWW account
> (pair networks), and I want to be able to upload/download tables from
> one to the other.
>
Dear Lawrence,
In a script you can use:
- mysql -e "SELECT ... INTO OUTFILE..." to execute a MySQL command
- mysqlimport --host=... --port=... to import the data to another host
Regards,
Jani
--
+---------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Jani Tolonen |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto: jani@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Helsinki |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Finland |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+---------------------------------------------------------------------+
