From: Claudio Nanni
Date: March 11 2009 1:22pm
Subject: Re: mysqlimport remote host problem
List-Archive: http://lists.mysql.com/mysql/216672
Message-Id: <53bcf3a60903110622w71ec794qb7ca05f8428bca64@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=001485f040928046f10464d7c3d0

--001485f040928046f10464d7c3d0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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=E9 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 t=
he
> > 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
>

--001485f040928046f10464d7c3d0--