Re: Upgrading from 4.0 to 4.1

>>
>> I don't seem to be able to find an upgrade document for 4.0 to 4.1.
>
> It's part of the official manual:
>
> <http://dev.mysql.com/doc/refman/4.1/en/upgrade.html>
>
>> What else do I need to save/backup/do?
>
> Read and *understand* (this is not optional) about new character
> encoding stuff in 4.1. Probably you have to do some refactoring
> in your application(s) to avoid character set problems.
>

Thanks

I am using the same data for development on 2 servers, and 1 'live' server.
2 of them are 4.1, (1 dev and 1 live), the other dev is 4.0.

The 4.0 is a development machine so I usually dump the data from the live
machine and upload it to the 4.0 development machine, (I do the same with
the 4.1 machine but not very often as it is not used for data tests).

So it is safe to assume that I have been
1- Somewhat lucky never to run into troubles
2- Almost certainly not using MySql to it's full potential
3- All the test results I have come to are not really useful as 4.0 and 4.1
are so different.

If I have been lucky then I guess I could remove 4.0 from the dev machine,
install 4.1 and upload the data again.
All I really need to do is save my current passwords, (so I can set them to
the same on the new install), reload the backup data from the 4.1 machines
and I should be ok.

What do you think?

Simon