Upgrading from 4.0 to 4.1

Hi,

I don't seem to be able to find an upgrade document for 4.0 to 4.1.

It simply says remove version 4.0 and install 4.1

I don't really want to do that as I am sure I must backup at the very least
my database(s).
But then I also need to backup my 'ini' file.

What else do I need to save/backup/do?

Many thanks.

Simon

"Simon" <spambucket@example.com> wrote:
>
> 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.


XL
--
Axel Schwenke, Senior Software Developer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/

"Axel Schwenke" <axel.schwenke@gmx.de> wrote in message
news:f3oevd.m19.ln@idefix.xl.local...
> <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.

Another gotcha between 4.0 and 4.1: passwords for MySQL accounts are
incompatible between these two versions. You should run 4.1
with --old-passwords, or else you have to reset all accounts' passwords.

See http://dev.mysql.com/doc/refman/4.1/...d-hashing.html and
http://dev.mysql.com/doc/refman/4.1/en/old-client.html

Regards,
Bill K.

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