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