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 > >
