CentOS - Dec 2006 - mysql issue

I am using the following command:
mysql -u cgalliance -p cgatesting < cgavb3.gz

I then type in the correct password and i get this returned:
ERROR at line 1: Unknown command '\'.

Any ideas?


-- 
My "Foundation" verse:
Isa 54:17  No weapon that is formed against thee shall prosper; and 
every tongue that shall rise against thee in judgment thou shalt 
condemn. This is the heritage of the servants of the LORD, and their 
righteousness is of me, saith the LORD.

-- carpe ductum -- "Grab the tape"
CDTT (Certified Duct Tape Technician)

Linux user #322099
Machines:
206822
256638
276825
http://counter.li.org/

William Warren wrote:
> I am using the following command:
> mysql -u cgalliance -p cgatesting < cgavb3.gz
>
> I then type in the correct password and i get this returned:
> ERROR at line 1: Unknown command '\'.
>
> Any ideas?
>
>
are you really trying to feed gzip'd data to mysql?

i think my backup went wonky.  I am redoing the dump


William Warren wrote:
> I am using the following command:
> mysql -u cgalliance -p cgatesting < cgavb3.gz
> 
> I then type in the correct password and i get this returned:
> ERROR at line 1: Unknown command '\'.
> 
> Any ideas?
> 
> 
-- 
My "Foundation" verse:
Isa 54:17  No weapon that is formed against thee shall prosper; and 
every tongue that shall rise against thee in judgment thou shalt 
condemn. This is the heritage of the servants of the LORD, and their 
righteousness is of me, saith the LORD.

-- carpe ductum -- "Grab the tape"
CDTT (Certified Duct Tape Technician)

Linux user #322099
Machines:
206822
256638
276825
http://counter.li.org/

On Mon, 11 Dec 2006, William Warren wrote:
> I am using the following command:
> mysql -u cgalliance -p cgatesting < cgavb3.gz
Perhaps it would be wise to decompress the file first:

# gzip -dc cgavb3.gz | mysql -u cgalliance -p cgatesting

-- 
Paul Heinlein <> heinlein at madboa.com <> www.madboa.com

Hello Family,

I've just purchased a 1-gig Sandisk "Cruzer" pendrive for I need
to have
the full "first" iso image to reside on the drive.

I need to have it boot as would a USB CDROM so I can initiate an NFS
install at the (install) command prompt with:

	linux text askmethod

I received this USB Flash Drive with a fat32 file system on in and was
thinking of just taking my first CD of CentOS and doing:

	dd if=/dev/hdc of=/dev/sda

I was thinking the above syntax from the days of using "dd" for floppy
boot images to 1.44mb floppy disks.

Any ideas on this?

TIA

-- 
  Bill Schoolcraft <*> http://wiliweld.com

"Health nuts are going to feel stupid someday,
    lying in hospitals dying of nothing."
                -- Redd Foxx

yOn Mon, 11 Dec 2006, William Warren wrote:
> I am using the following command:
> mysql -u cgalliance -p cgatesting < cgavb3.gz
>
> I then type in the correct password and i get this returned:
> ERROR at line 1: Unknown command '\'.
one as to be suspicious of the script -- I do such testing 
this way, so that I can see everything:

$ cat - << END | mysql -u userid -h hostname datasetname
drop database datasetname;
create database datasetname;
quit;
END

adding the -p option for a passworded mysql account will is 
straightforward, and the mysql shell will still prompt

sample at:
 	http://www.trading-shim.org/pipermail/ts-general/2006-November/000035.html

-- Russ Herrold