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.
/home/mysql5123)
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!
Claudio
2009/3/22 s...@twinix.com
See Thread at: http://www.techienuggets.com/Detail?tx=78654 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: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
