So what you are doing here is sending some sql statements from the dump to mysql CLI, so all that in going into the pipe is just plain text output from the dump, it does pass in any auth parameters, so for your script to run just add the required user, pwd etc as arguments to the mysql cli utility, and it will happily run. like this below ........
#mysqldump ....... | mysql -u<user> -p<password> Kishore Jalleda http://kjalleda.googlepages.com/projects On 4/1/06, Anton Statutov <[EMAIL PROTECTED]> wrote: > > On FreeBSD 5.3. MySQL 4.1.15 unix pipeline like "mysqldump ... | mysql > ..." causes an auth error in the second command, even different > databases are used. What does it mean? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
