[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