470,613 Members | 2,448 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,613 developers. It's quick & easy.

import users from old mysql db?

We're in the middle of upgrading from MySQL 3.23 to MySQL4.1.

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
the tables.

Is there a quick and easy way to do this import?

Thanks in advance.

Mar 13 '06 #1
1 1209
<ji*********@gmail.com> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
We're in the middle of upgrading from MySQL 3.23 to MySQL4.1.
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/...d-hashing.html for more
information.
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).


Did you run mysql_fix_privilege_tables after the restore?
http://dev.mysql.com/doc/refman/4.1/...ge-tables.html

Also you should review these pages to see if there's anything else that
applies to your upgrade:
http://dev.mysql.com/doc/refman/4.1/...from-3-23.html
http://dev.mysql.com/doc/refman/4.1/...-from-4-0.html

Regards,
Bill K.
Mar 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Mario Ohnewald | last post: by
2 posts views Thread by Brian Huether | last post: by
4 posts views Thread by news | last post: by
7 posts views Thread by phillip.s.powell | last post: by
7 posts views Thread by Randy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.