On 10/30/05, C. Beamer <[EMAIL PROTECTED]> wrote: > 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?
What was the error message, if it was about the key length exceeding 1000, then you hit a known bug. -- Joe -- There are 3 kinds of people in the world: Those who can count, and those who can't. -- gentoo-user@gentoo.org mailing list