Re: mysql upgrade broke server [solved!]
On Sat, Nov 11, 2006 at 12:25:39AM +0100, Florian Kulzer wrote:
> On Fri, Nov 10, 2006 at 17:54:10 -0500, Rick Pasotto wrote:
> > On Fri, Nov 10, 2006 at 11:20:50PM +0100, Florian Kulzer wrote:
> > > On Fri, Nov 10, 2006 at 16:39:23 -0500, Rick Pasotto wrote:
>
> > > If you still need a "real" 4.1 package to fix some things before the
> > > upgrade, then you will have to find an older version, either in your
> > > /var/cache/apt/archives/ directory or from snapshot.debian.net. Once you
> > > have found the right .deb file you can install it with "dpkg --install".
> >
> > So I added to /etc/apt/sources.list:
> >
> > deb http://snapshot.debian.net/archive pool mysql-dfsg-4.1
> >
> > and updated. Now what?
> >
> > 'apt-get install mysql-dfsg-4.1' says it can't find the package.
>
> apt-get install mysql-server-4.1=<some-version-identifier>
>
> "apt-cache policy mysql-server-4.1" will tell you which versions are
> available. Replace <some-version-identifier> with the number of the
> version that you want. I would try the newest one that is still a full
> package. "apt-cache show mysql-server-4.1" will print the descriptions
> of all versions so you can check for the last one that does not have
> "This is an empty transitional package and can safely be removed" in
> the package description.
I managed to solve the problem. There may be a better/faster way, but
this is what I did:
download from security.debian.org
mysql-client-4.1_4.1.11a-4sarge7_i386.deb
mysql-common-4.1_4.1.11a-4sarge7_all.deb
mysql-server-4.1_4.1.11a-4sarge7_i386.deb
dpkg -i --force all mysql-common-4.1_4.1.11a-4sarge7_all.deb
dpkg -i --force all mysql-client-4.1_4.1.11a-4sarge7_i386.deb
dpkg -i --force all mysql-server-4.1_4.1.11a-4sarge7_i386.deb
Then I ran 'alter table xxx type=MyISAM' on the offending tables. Then:
apt-get -f install
(which dl'd the above from snapshot)
And finally:
apt-get install mysql-server
which gives me a 5.0 install.
Whew!
--
"Words are, of course, the most powerful drug used by mankind."
-- Rudyard Kipling
Rick Pasotto rick@niof.net http://www.niof.net
Reply to: