[CentOS] mysql issue

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