MySQL Forums
Forum List  »  Backup

Mysqldump command problem
Posted by: RajeshKumar
Date: November 24, 2005 03:03AM

Hi,
I'm having problems with the "mysqldump". I'm maintaining a database for my project in MySql. For safety purpose i take backup of my database using the command
" mysqldump -A -u username -p password > filename.sql "

This is taking backup successfully. But, when i restore the database with this new backup, the password field is not getting automatically encoded. I h'v to encode it separately using the update query. But it is not good in the case of a clientside to restore the backup and use the update query for encoding. It must be automatically encoded after restoring the backup.
Anyone who know the way to solve this problem plz send elaborate explanation to my mail-id b_rajkumarmca@yahoo.co.in
Thanks in Advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysqldump command problem
5636
November 24, 2005 03:03AM
2659
November 24, 2005 11:48PM
2373
November 25, 2005 01:18AM
2598
December 01, 2005 06:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.