List:General Discussion« Previous MessageNext Message »
From:Rob Wultsch Date:March 11 2009 3:36am
Subject:Re: mysqlimport remote host problem
View as plain text  
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