List:General Discussion« Previous MessageNext Message »
From:Jani Tolonen Date:April 15 1999 4:16pm
Subject:OUTFILE to Another Host
View as plain text  
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   |
+---------------------------------------------------------------------+
Thread
OUTFILE to Another HostLawrence Blades15 Apr
  • Re: OUTFILE to Another HostPaul DuBois15 Apr
  • OUTFILE to Another HostJani Tolonen15 Apr
  • Re: OUTFILE to Another HostSasha Pachev15 Apr