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
