Uninstalling MariaDB

neobim · Jan 25, 2016

Host installed my server's DirectAdmin with MariaDB, but I need MySQL...

I've changed mysql_inst from mariadb to mysql, but now when I run custombuild it tells me this:

Code:

mysql_inst=mysql is set in the options.conf, but MariaDB is currently installed
If you wish to use MySQL, please remove MariaDB and install MySQL before setting CustomBuild to manage it.

How can I uninstall MariaDB?

It was installed with custombuild, so it's not available for apt-get remove or anything.
dpkg -l doesn't show anything MariaDB or MySQL related.

Server is running Debian Jessie.

Any nudge in the right direction would be appreciated. Thanks.

smtalk · Jan 25, 2016

For debian, please use:

Code:

rm -f /usr/local/mysql/bin/mysql
cd /usr/local/directadmin/custombuild
./build mysql

neobim · Jan 25, 2016

Thanks for the quick response, Martynas! Didn't realize all I needed to do was delete the binary.

Got MySQL built and everything seems to be working now. Thanks!

babak · Sep 5, 2016

smtalk said:
For debian, please use:

Code:

rm -f /usr/local/mysql/bin/mysql cd /usr/local/directadmin/custombuild ./build mysql

Hello,
What about CentOS7?
How can I uninstall MarianDB?

Thank you

smtalk · Sep 5, 2016

Code:

mv /usr/bin/mysql /usr/bin/mysql_backup
cd /usr/local/directadmin/custombuild
./build set mysql_inst mysql
./build mysql

Pauchri · Oct 15, 2016

Can you please tell what the code is for centos 6.8.
How can I uninstall MarianDB?
Thanks

zEitEr · Oct 16, 2016

The same as here in Martynas's post #5 it's not CentOS version specific.

ptedomains · Oct 20, 2016

Not working for me.

OK. I followed all the fixes advised here with taking out mariadb, now when i try to update and build versions, the following error prompts me.

Code:

[root@web custombuild]# /usr/local/directadmin/custombuild/build update_versions
apache webserver configuration option is not compatible with php-fpm, lsphp or php-fastcgi PHP mode with mod_ruid2 enabled.

Can you please advise me.

zEitEr · Oct 23, 2016

The best piece of advise I could give you is that you should

1. carefully read what you get in the output
2. carefully read the FAQ: https://forum.directadmin.com/showthread.php?t=44743

If you don't want to spend time on reading the basics, then you'd better hire someone from these forums to set it up for you.

BakkerM · Nov 12, 2016

Yikes!

smtalk said:
For debian, please use:

Code:

rm -f /usr/local/mysql/bin/mysql cd /usr/local/directadmin/custombuild ./build mysql

Sorry for hijacking this thread, but it didn't make sense to create a new one.

I did the aboven and then ran:

Code:

   cd /usr/local/directadmin/custombuild
   ./build set mysql 5.6
   ./build set mysql_inst mysql
   ./build set mysql_backup yes
   ./build update
   ./build mysql

It goes compiling or whatever it's doing and then I get this:

root@ns1:/usr/local/directadmin/custombuild# ./build mysql
./build: line 7164: /usr/local/mysql/bin/mysql: No such file or directory
converted 'http://files6.directadmin.com/services/all/mysql/debian/64-bit/mysql-5.6.34-linux-x86_64.tar.gz' (ANSI_X3.4-1968) -> 'http://files6.directadmin.com/services/all/mysql/debian/64-bit/mysql-5.6.34-linux-x86_64.tar.gz' (UTF-8)
--2016-11-12 12:27:17-- http://files6.directadmin.com/services/all/mysql/debian/64-bit/mysql-5.6.34-linux-x86_64.tar.gz
Resolving files6.directadmin.com (files6.directadmin.com)... 62.148.174.106, 2001:16e8:1:c:62:148:174:106
Connecting to files6.directadmin.com (files6.directadmin.com)|62.148.174.106|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2016-11-12 12:27:17 ERROR 404: Not Found.

Failed to download http://files6.directadmin.com/services/all/mysql/debian/64-bit/mysql-5.6.34-linux-x86_64.tar.gz. Exiting...

Any idea, or solution for this?

I checked the files at the URL in question and indeed there is no 5.6.34 version, only 5.6.12.

Thanks in advance.

Regards

BakkerM · Nov 12, 2016

Update:

I followed the information on this page: https://help.directadmin.com/item.php?id=650

cd /usr/local/directadmin/custombuild
./build set mysql_force_compile yes
./build mysql

However this also returns in an error...

root@ns1:/usr/local/directadmin/custombuild# ./build mysql
./build: line 7164: /usr/local/mysql/bin/mysql: No such file or directory
Attempting to compile a package from source...
Extracting mysql-5.6.34.tar.gz ...
cmake: /usr/local/lib/libcurl.so.4: no version information available (required by cmake)
./build: line 7061: 2301 Segmentation fault cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_ZLIB=bundled -DWITH_EXTRA_CHARSETS=all
Done. Making mysql-5.6.34...
Trying to make mysql-5.6.34...
make: *** No targets specified and no makefile found. Stop.

*** The make has failed, would you like to try to make again? (y,n):

zEitEr · Nov 13, 2016

You might consider migrating to MariaDB then:

Code:

cd /usr/local/directadmin/custombuild
./build update
./build set mysql_force_compile no
./build set mysql_inst mariadb
./build set mariadb 10.0
./build mysql

BakkerM · Nov 14, 2016

MariaDB 10.x is not an option, as it's not supported with the backup option we offer to our customer (from IASO).
So that's a no-go.

So we really need MySQL 5.6, currently I have managed to get MySQL 5.5 installed, but 5.6 is a problem.
Maybe I should recommend Plesk to the customer instead...?

zEitEr · Nov 14, 2016

It's a community forums. For an official help from Directadmin developers you should open a ticket with them.

BakkerM · Nov 14, 2016

Ah no worries, I will inform the customer to order Plesk. This is taking way too much time.
Thanks nevertheless.

zEitEr · Nov 14, 2016

Hey, be sure we are always ready to help when we have free time for it. I don't have those errors in my records, so that I could provide a quick way fix or solution, and did not have issues with upgrading MySQL 5.6 on Debian servers (recently upgraded 2 servers) . It would much take less time to fix it on a board if you get someone from active users here to do it for you.

If you want a solution and have time to debug it, then we could "chat" it here:

what I would try is to

1. remove complete MySQL (is Debian or Centos server?)
2. install MySQL with custombuild or /usr/local/directadmin/scripts/mysql.sh once again

ditto · Nov 14, 2016

MvdL said:
[..]And apparently MariaDB 5.6 is not available for DA (unlike for Plesk).

MariaDB 5.6 does NOT exist, please see https://downloads.mariadb.org/mariadb/+releases/ - so MariaDB 5.6 is NOT available for Plesk or any other control panel. It does NOT exist!

SeLLeRoNe · Nov 14, 2016

And for the record, MariaDB 10 should be consider as a MySQL 5.6, so you shoudln't have issue with backups if they would work for MySQL 5.6

Best regards

iSoheil · Aug 26, 2020

smtalk said:

Hello, I have that problem with CentOS8.
Can I ask "How to remove (Uninstall) MariaDB from CentOS8 version.
Thanks a lot.

Zhenyapan · Aug 29, 2020

iSoheil said:
Hello, I have that problem with CentOS8.
Can I ask "How to remove (Uninstall) MariaDB from CentOS8 version.
Thanks a lot.

you can't remove, you can replace it by Mysql. Just make backups, (I'm using "admin backup/transfer" with selected database data/settings) remove/rename old mysql/maria directory (usually /var/lib/mysql)
then: https://help.directadmin.com/item.php?id=240

Uninstalling MariaDB

Verified User

Administrator

Verified User

New member

Administrator

New member

Super Moderator

New member

Super Moderator

Verified User

Verified User

Super Moderator

Verified User

Super Moderator

Verified User

Super Moderator

Verified User

Super Moderator

New member

Verified User