import users from old mysql db?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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?

Quoted text here. Click to load it

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 for more

Quoted text here. Click to load it

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:

Bill K.

Site Timeline