List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:March 11 2009 1:22pm
Subject:Re: mysqlimport remote host problem
View as plain text  
zcat /Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql.gz | mysql -h
192.168.0.224 -u root -p alba2

Cheers

Claudio



2009/3/11 Rob Wultsch <wultsch@stripped>

> 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