List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:March 22 2009 8:03am
Subject:Re: Upgrading MySQL from 5.0 to 5.1
View as plain text  
What I always did since 3.23 upwards is new installation and import.
My tecnique allows me to install as many mysql instances as I want,
I always use specific user, homedir, datadir, my.cnf, for each installation.
In this way I can have theoretically unlimited number of mysql instances on
one host.
In your case I would install the new 5.1 in a custom home (e.g.
use your previous my.cnf from the 5.0 installation to get all previous
settings and make it use the same datadir.
To force one installation to use ONE AND ONLY ONE my.cnf start the instance
with the command line option:
(E.g. --defaults-file=/home/mysql5123/my.cnf)
in this way no side effects will take place (as long you configure correctly
my.cnf to work from the new home)

let me know if this is enough, enough clear or just was better for me to
shut up!


2009/3/22 <samk@stripped>

> See Thread at: Posted on
> behalf of a User
> This has proved to be quite challenging. I wasn't able to do the upgrade
> and basically created another instance of 5.1 and took a backup of my
> database from 5.0 and restored it to 5.1. Then added all my users, etc.
> There's got to be a better way?
> I couldn't figure out how to get the new version 5.1 to see the file system
> (containing the database) that was in use by 5.0. I looked at all the
> documents and nowhere (or at least I couldn't see it) does it talk about
> upgrading the database. When you install the new version how do you get it
> ot upgrade and use the 5.0 database? Any pointers/help on this would be
> great for the next time I have to do this.
> Thanks.
> --
> MySQL General Mailing List
> For list archives:
> To unsubscribe:

Upgrading MySQL from 5.0 to 5.1samk22 Mar
  • Re: Upgrading MySQL from 5.0 to 5.1Claudio Nanni22 Mar