On Sunday 30 October 2005 05:15 pm, C. Beamer wrote: > 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.
The problem here, is your not giving us enough to say what really went wrong with the restore. If you have innodb tables, for example, you can't just restore them in all cases, without tweaking things a bit.. Your just assuming what the issue was, and telling us, then saying we should tweak things based off something you really dont know.. I have never had a major problem restoring a db. I have had to make tweaks in MANY cases, however.. So I would get the error message, then we can discuss how to fix your case. That step by step guide really isnt gonna work in all situations.. Nothing personal to anyone, but there are too many situations out there, and the backup/restore in mysql isnt really the best.. Besides, I have never had problems with just upgrading, doing the upgrade guide what mysql says.. I have never restored anything to upgrade. Jeff
pgpqxSue0hDSW.pgp
Description: PGP signature
