Qian Qiao wrote: >>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. > > No, I didn't get any error messages on restoring the database that was created by the backup process that was included in the instructions. Also, the process for fixing the grant tables was fine. However, when I started mysql and tried to use the database, I was told that the database didn't exist and upon checking, I discovered that the only database that was there was "test".
So, in essence, the restore *did* work, but the backup just didn't pick up my database. Regards, Colleen -- gentoo-user@gentoo.org mailing list
