Upgrading MySQL Server

Forum Moderators: open

Message Too Old, No Replies

Upgrading MySQL Server

carfac

5:15 pm on Nov 14, 2007 (gmt 0)

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

2:40 am on Nov 15, 2007 (gmt 0)

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

2:49 am on Nov 15, 2007 (gmt 0)

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