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.

Re: import users from old mysql db?

wrote in message
news:1142286751.913287.121130@u72g2000cwu.googlegroups.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/en/password-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/en/mysql-fix-privilege-t ables.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/en/upgrading-from-3-23.h tml
http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.ht ml

Regards,
Bill K.