[CentOS] mysql issue

Mon Dec 11 18:36:31 UTC 2006
R P Herrold <herrold at owlriver.com>

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;

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

sample at:

-- Russ Herrold