Home > Archive > MySQL ODBC Connector > April 2006 > Strange thing









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Strange thing
Anton Statutov

2006-04-01, 9:28 am

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/mysql? unsub...sie.nctu.edu.tw

Kishore Jalleda

2006-04-03, 11:26 am

------ =_Part_1701_12577335
.1144079183187
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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 fro=
m
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 <stant@bestyle.ru> 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/mysql? unsub...ma
il.co=

m
>
>


------ =_Part_1701_12577335
.1144079183187--
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com