Upgrading MySQL Server

[carfac]

Next week, I will be changing out my current MySQL server to a brand new one.

What is the best way to transfer all the databases and data? I am pretty slow, so a step-by-step of the commands would help me a lot.

[phranque]

what os are you using?
(which would help with guessing which command syntax to use)

as far as moving the data, i would simply use mysqldump to create a file for each db and pipe those files into mysql when you get the new server set up.

[bunltd]

I've upgraded without having to do much beyond issuing the command, the host I use for this particular site has commands to upgrade/install a higher version and that did everything - including converting existing databases with their data and users. Your situation may be different and I'd make a backup just in case.

LisaB