i wasn't using a script that was hand typed..the error threw me..<G> However it turns out it as a bad dump. R P Herrold wrote: > 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 > _______________________________________________ > CentOS mailing list > CentOS at centos.org > http://lists.centos.org/mailman/listinfo/centos > > -- 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/