obvious way of migrating 3.x sol8 to 4.1 on sol 9

[tony]

Hello,

Have small job for next weekend. Need to migrate 8 GB mysql 3.x from
sol 8 netra T1 to 4.1 on sol 9 sunfire 210. No X available for whizzy
GUI.
Is there an obvious approach to doing this?
And caveats or gotchas? Any fine manuals I shoul dread beforehand?

TIA

Tony

[Bill Karwin]

tony wrote:

Have small job for next weekend. Need to migrate 8 GB mysql 3.x from
sol 8 netra T1 to 4.1 on sol 9 sunfire 210.
1. Log into netra host.
2. mysqldump --opt --databases mydatabase |
mysql --compress -h sunfirehostname

You might want to try this with a test database first to make sure it
works in your environment. You might also need to specify username and
password for one or both commands in that pipeline.
And caveats or gotchas? Any fine manuals I should read beforehand?

The first one that comes to mind is that the password encryption has
changed with 4.1. (see
http://dev.mysql.com/doc/mysql/en/password-hashing.html)

If you need to migrate the 'mysql' database to preserve users'
passwords, you might want to start mysqld on the new server with the
--old-passwords option.

You should also read the relevant pages at
http://dev.mysql.com/doc/mysql/en/upgrade.html
to see if any of the changes might affect you.

Regards,
Bill K.