Re: [gentoo-user] MySQL Upgrade

[Jeff Smelser]

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