Re: upgrade from 4.1 to 5.5

[Florin P]

Sam,

Did you manage to finish successfully the upgrade?

I have inherited a rather old Windows version of MySql 4.0.20a running on a Windows 2003 Server Standard 32bit.
The engine used is MyISAM.

I would like to be able to transfer the database to a CentOS 6.3 64it server, running MySql 5.1.61 (distro default version)

What steps out of the 23 listed do you think would apply to my situation?

I did a mysqldump for all the databases:

d:\dbms\bin>mysqldump.exe -uroot -pPASSWORD --all-databases > d:\backup\all-oldserver_test001.sql

Also I did do a mysqldump for each database as well:

D:\dbms\bin>mysqldump.exe -uroot -pPASSWORD calendar > d:\backup\calendar-olserver_test001.sql

D:\dbms\bin>mysqldump.exe -uroot -pPASSWORD products > d:\backup\products-olserver_test001.sql

etc...

I am _very_ new to the MySql stuff (or any sql server) and I would appreciate all the advice I would get!

Thanks,

Florin



Edited 2 time(s). Last edit at 11/14/2012 09:54AM by Florin P.