2 messages in com.mysql.lists.eventum-usersRe: Users Migration from Mysql 3.23 -...
FromSent OnAttachments
Anthony Assi17 Feb 2006 01:25 
Georger Araujo17 Feb 2006 04:27 
Subject:Re: Users Migration from Mysql 3.23 -> 4.1
From:Georger Araujo (geor@yahoo.com.br)
Date:02/17/2006 04:27:16 AM
List:com.mysql.lists.eventum-users

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?