migrating mysql to other server. How to migrate varchar(16) char encrypted password field ?

Question

We are migrating mysql database to other server. we have a users table where the password field ( varchar(16) )is encryted based on encryption key. How do I transfer this data to other database ? How do make sure that data is transferred correctly. Having problems..

Answer 1

well; 2 solutions;



(*) run mysqldump against the db and redirect it to a .sql file; then restore it using mysql



eg:

mysqldump -u root db_name > somefile.sql

mysql -u root < somefile.sql



(*) this is a wild method: copy the "your_db_name" folder; usually in "data" folder of mySQL to the new db server; [ not advisable if the table is accessible for a particular role ]

Answer 2

hi



password field encrypted ? or value inside password field encrypted if dat is the case then there is no problem shifting the database to other server

Answer 3

hum a password gate if thats what your looking for go to bravenet.com