Delete/remove/purge Ubuntu's MySQL

neo-hippie

Verified User
Joined
May 27, 2014
Messages
69
Location
The Netherlands (Holland)
Hello,

i know somehow i made a booboo (do not correct me on that! I KNOW).

Somehow i have Mysql 5.0 installed from Ubuntu's repository alongside Directadmin's Mysql 5.5
i believe it still persists from the first delivery from my hosting provider (all setup with LAMP / FTP and SSH)
but my understanding from http://forum.directadmin.com/showthread.php?t=44473 is that everything unnecessary is deleted by directadmin.

Okey so far the info.
Now every time i do a update/upgrade on Ubuntu it says Mysql needs upgrading.
John has told me once i needed to remove the /etc/mysql directory.
but it keeps coming back (the directory and the update warning)

so how can i SAFELY remove the Ubuntu's Mysql
or remove it from DPKG / APT so i can do a upgrade of Ubuntu.
can i do a purge mysql? or will it affect Directadmin's Mysql as well?

kind regards,
Arnold
 
Hello,

Here is what I'd do:

1. Create MySQL backups with MySQL tools or copy mysql data directory into secure place on HDD.
2. Remove MySQL installed from your OS distribution by apt-get
3. Re-install MySQL with custombuild (as might get corrupted when purging with apt-get)
4. Move/copy MySQL tables back
5. Re-compile PHP.
6. Check login credentials and phpmyadmin, as well as sites.

That's it.
 
Thanks Alex,

i'll give it a shot next weekend.
until than if anybody has additional pointers please tell.

this has been an headache file for some time now.
hope to fix that bug once and for all.
 
Okey i'm doing the remove now,
removal has gone fine. everything is still sort of up and running.

but when i want to build_versions for directadmin i get the following error on Mysql
EDIT: trying to do an update from: MySQL 5.5.38 to 5.6.19 update is available.

Attempting to compile a package from source...
Found old mysql-5.6.19, removing ...
Extracting mysql-5.6.19.tar.gz ...
Inconsistency detected by ld.so: dl-version.c: 224: _dl_check_map_versions: Assertion `needed != ((void *)0)' failed!
Done. Making mysql-5.6.19...
Trying to make mysql-5.6.19...
make: *** No targets specified and no makefile found. Stop.
 
Last edited:
Back
Top