Hi all, I just upgraded MySQL using the instructions on the Gentoo website. For the most part, everything went fine and now everything works, but I had to make a couple of adjustments. My question now is if there is a proper way to do what I did as a workaround.
In September, when I wiped Fedora Core off my main system and installed Gentoo, I had a MySQL database that I used for one reason and one reason only. To get my database files from the FC4 system to Gentoo, I just copied them to a ZIP drive. When I installed MySQL, in /var/lib/mysql/ I created a directory with the name of my database and copied my database related files into that directory. Then I set up the users allowed to access to the database. This worked fine and is the workaround that I had to do today after upgrading MySQL. The instructions on the Gentoo website for upgrading gave a step by step to create a backup of my database. However, when I went to restore the database after the upgrade, the restore didn't work. I'm thinking that it was because of the way I got my database files into MySQL when I initially installed MySQL under Gentoo. Is there a way to rectify this so that the backup will work for future upgrades? Regards, Colleen -- gentoo-user@gentoo.org mailing list
