Uninstalling MariaDB

neobim

Verified User
Joined
Jan 25, 2016
Messages
5
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.
 
For debian, please use:
Code:
rm -f /usr/local/mysql/bin/mysql
cd /usr/local/directadmin/custombuild
./build mysql
 
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!
 
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
 
Code:
mv /usr/bin/mysql /usr/bin/mysql_backup
cd /usr/local/directadmin/custombuild
./build set mysql_inst mysql
./build mysql
 
Can you please tell what the code is for centos 6.8.
How can I uninstall MarianDB?
Thanks
 
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.
 
Yikes!

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
 
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):
 
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


 
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...?
 
Last edited:
It's a community forums. For an official help from Directadmin developers you should open a ticket with them.
 
Ah no worries, I will inform the customer to order Plesk. This is taking way too much time.
Thanks nevertheless.
 
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
 
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
 
Code:
mv /usr/bin/mysql /usr/bin/mysql_backup
cd /usr/local/directadmin/custombuild
./build set mysql_inst mysql
./build mysql

Hello, I have that problem with CentOS8.
Can I ask "How to remove (Uninstall) MariaDB from CentOS8 version.
Thanks a lot.
 
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
 
Back
Top