Hi couldn't understand why apt-get would always give the following error when trying to downgrade mysql on ubuntu:
After deleting that directory, I ran the following command, and had mysql setup and ready to go:
Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.51a-3ubuntu5.4_amd64.deb) ...Finally figured it out. For downgrading, you must delete /var/lib/mysql directory.
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)
After deleting that directory, I ran the following command, and had mysql setup and ready to go:
sudo apt-get -f install