Thursday, March 26, 2009

Mysql 5.1 downgrade to Mysql 5.0 on Ubuntu Intrepid Ibex

Hi couldn't understand why apt-get would always give the following error when trying to downgrade mysql on ubuntu:

Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.51a-3ubuntu5.4_amd64.deb) ...
Aborting downgrade from (at least) 5.1 to 5.0.
dpkg: error processing /var/cache/apt/archives/mysql-server-5.0_5.0.51a-3ubuntu5.4_amd64.deb (--unpack):
 subprocess pre-installation script returned error exit status 1
Errors were encountered while processing:
 /var/cache/apt/archives/mysql-server-5.0_5.0.51a-3ubuntu5.4_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
Finally figured it out. For downgrading, you must delete /var/lib/mysql directory.

After deleting that directory, I ran the following command, and had mysql setup and ready to go:

sudo apt-get -f install
Posted by at

14 comments:

  1. MarceloMay 23, 2009 at 4:56 PM

    thanks a lot!!!
    i couldn't downgrade from mysql 5.1 to 5.0 , and i've search in a lot of forums and i didn't found anything usefull.
    The answer is delete de directory as you said.

    mbarria

    ReplyDelete
  2. SenseqMay 26, 2009 at 8:41 PM

    You're very welcome Marcelo - glad this was of help :-)

    ReplyDelete
  3. AkomMay 30, 2009 at 10:25 AM

    Thank you, helped me as well - couldn't find this answer on the first 15 sites I looked :)

    ReplyDelete
  4. DźwiedziuJune 22, 2009 at 5:06 AM

    Well, just don't ask where your databases went and why to hell.

    I found it simpler to (re)move debian-5.1.flag and mysql_upgrade_info from that directory.
    Of course that flags aren't for nothing, so be warned that your mileage may vary.

    ReplyDelete
  5. Gustavo Menezes GonçalvesAugust 15, 2009 at 6:02 PM

    Thanks a lot!!! You are a life saver...

    ReplyDelete
  6. SenseqAugust 15, 2009 at 8:56 PM

    You're welcome Gustavo. I'm glad this was of help!

    ReplyDelete
  7. jhauserOctober 6, 2009 at 4:29 AM

    Thanks alot, though you DO NOT need to delete the whole directory, it is sufficient to remove the flag file located inside the directory, at least for me that worked.

    ReplyDelete
  8. GerryApril 3, 2010 at 2:05 PM

    cheers :)

    ReplyDelete
  9. UnknownMay 27, 2010 at 1:40 AM

    I love you! You're my hero!

    ReplyDelete
  10. SenseqJune 26, 2010 at 12:21 PM

    Lol - you're very welcome, Sebastian. I'm glad this was of help!

    ReplyDelete
  11. UnknownJune 29, 2010 at 9:02 PM

    @Dźwiedziu
    Thank goodness I saw your post I almost killed all my data... Your suggestion worked perfectly!!!
    Just delete those 2 files

    ReplyDelete
  12. DanAugust 31, 2010 at 1:53 PM

    Thank you very much for this, even a year later..I fubar'd my Nagios install, at least some dependency on apache2....im stupid but you saved me! Thanks again.

    ReplyDelete
  13. GonarhNovember 30, 2010 at 10:58 AM

    very very very much thanks!!! i have sex with this error 2 hour >:-(

    ReplyDelete
  14. David L. BompartOctober 4, 2011 at 9:25 AM

    rm /var/lib/debian-5.1.flag

    ReplyDelete

Subscribe to: Post Comments (Atom)