It goes without saying that you should have a TESTED
backup of your database before upgrading.
It looks like there's no way of upgrading directly
from 3.23 to 4.1.x, as per
http://dev.mysql.com/doc/refman/4.1/en/index.html - so
I think you should first upgrade to 4.0.x, then to
4.1.x.
Excerpt from the URL:
2.10. Upgrading MySQL
2.10.1. Upgrading from MySQL 4.0 to 4.1
2.10.2. Upgrading from MySQL 3.23 to 4.0
2.10.3. Copying MySQL Databases to Another Machine
Get the latest 4.0.x release from the following URL:
http://downloads.mysql.com/archives.php?p=mysql-4.0
The upgrade process should be straightforward. Read
the document below, including the comments:
http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-3-23.html
Then run the mysql_fix_privilege_tables script and you
should be all set:
http://dev.mysql.com/doc/refman/4.1/en/mysql-fix-privilege-tables.html
Hope this helps. Take these instructions with a grain
of salt, however, because I'm not exactly a MySQL
expert. Regards,
Georger
--- Anthony Assi <Anth...@irisa.fr> escreveu:
Hi,
I am Upgrading our server, i am upgrading from Mysql
*3.23.52 to **4.1.12,
*I have noticed a difference between the 2 User
table structure in the Mysql DB.
...
How can i migrate the Users?