[NBLUG/talk] MySQL Migration..

[Susan Baur]

Hi Steve,

You should be able to use mysqldump to get the data out of your 3.x  
db and import it into 5.x. The biggest issue I had when doing a  
similar upgrade to 4.1 was that MySQL changed their password hashing  
algorithm between those two versions.

from http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html

After upgrading, update the grant tables to obtain the new longer  
Password column that is needed for more secure handling of passwords.  
The procedure uses mysql_fix_privilege_tables and is described in  
Section 5.5.4, “mysql_fix_privilege_tables — Upgrade MySQL System  
Tables”[http://dev.mysql.com/doc/refman/4.1/en/mysql-fix-privilege- 
tables.html]. If you do not do this, MySQL does not use the new more  
secure protocol to authenticate. Implications of the password- 
handling change for applications are given later in this section.

If for some reason (e.g. your webapp doesn't know any better) you  
need to continue using the old style passwords with your upgraded  
database, there's also a command line option you can set (--old- 
passwords) that will force it to the older passwords. Also see http:// 
dev.mysql.com/doc/refman/5.1/en/password-hashing.html for more info  
on this.

HTH,
--Susan


On May 31, 2007, at 12:33 PM, Steve Johnson wrote:

> I have a project where I have to migrate from a MySQL 3.x server to a
> MySQL 5.x server.  This is a 'Customer' database server, so I wont
> have passwords, except for the encrypted version in the mysql
> databases user table.
>
> My Questions are.. 1) Is there a tool that will do this for me? and 2)
> If I have to end up doing this by hand, what are some gotcha's I need
> to look out for?
>
> There are about 50 accounts, so if I can possible do this with a tool,
> that would be awesome! (Each account has 3 logins, a read, a
> readwrite, and an admin.)
>
> Any help would be mucho appreicated..
>
> Thanks.
>
> -Steve
>
> -- 
> Blog - http://www.fratm.com/index.php/User:Fratm
> "Knowing others is wisdom, knowing your self is Enlightenment." -  
> Lao-Tzu
>
> _______________________________________________
> talk mailing list
> talk at nblug.org
> http://nblug.org/cgi-bin/mailman/listinfo/talk
>