Restore Not working for encoded passwords

[Balakrishnan K]

I am using mysql 4.1.7 server. In my database i have a table for username and password. In this table the username is a varchar field and password is password field. I use to store the password by using the encode function.
And it works well while retrieve the password using decode function.

But when the backup sql script (taken by mysqldump utility) is executed, it also executes . But i can't retrive my password using decode function.Yes the password is changed and becomes unpredictable.

Though there are 1000s of usernames and passwords , it causes very big problem.

So kindly tell me the way of dumbing or executing the script.

Thank you.