List:General Discussion« Previous MessageNext Message »
From:René Fournier Date:March 11 2009 3:45pm
Subject:Re: mysqlimport remote host problem
View as plain text  
Thanks. That works great.


On 10-Mar-09, at 9:36 PM, Rob Wultsch wrote:

> On Tue, Mar 10, 2009 at 7:16 PM, René Fournier <m5@stripped>  
> wrote:
>
>> OK, I've managed to do the same thing with just the mysql command  
>> line
>> program:
>>
>>       mysql -h 192.168.0.224 -u root -p alba2 <
>> /Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql
>>
>> Works great. However, the sql file is normally gzipped, so.... Can  
>> I ungzip
>> the file on the fly (and without removing the .gzip version) and  
>> pipe the
>> contents as I did above? (Yes, I'm UNIX-impaired.)  Something like:
>>
>>       mysql -h 192.168.0.224 -u root -p alba2 < gzip -dc
>> /Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql.gz
>>
>> But so that it works...
>>
>> ...Rene
>
>
> Pipe is your friend. You probably want something like:
>
> gzip -dc /Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql.gz
> | mysql -h 192.168.0.224 -u root -p alba2

Thread
mysqlimport remote host problemRené Fournier11 Mar
  • Re: mysqlimport remote host problemRené Fournier11 Mar
    • Re: mysqlimport remote host problemDarryle Steplight11 Mar
      • Re: mysqlimport remote host problemwultsch11 Mar
    • Re: mysqlimport remote host problemRob Wultsch11 Mar
      • Re: mysqlimport remote host problemClaudio Nanni11 Mar
      • Re: mysqlimport remote host problemRené Fournier11 Mar