Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- import users from old mysql db?
March 13, 2006, 9:52 pm
rate this thread
I'm trying to import all of the info in the mysql database (ya know the
db that keeps track of all the users and what they can and cannot do).
I tried just a standard mysqldump from the old box. Copy the file over
to the new box. And do a mysql -uroot -p < /tmp/mysqldb.sql. Lo and
behold it doesn't work. Looks like there are more columns in some of
Is there a quick and easy way to do this import?
Thanks in advance.
Re: import users from old mysql db?
Note that the default password encoding in these two versions is
incompatible. None of your users' passwords will be recognized, unless you
start mysqld using the --old-passwords option.
See http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html for more
Did you run mysql_fix_privilege_tables after the restore?
Also you should review these pages to see if there's anything else that
applies to your upgrade:
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum