LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices


Reply
  Search this Thread
Old 03-27-2013, 01:49 AM   #1
vdemuth
Member
 
Registered: Oct 2003
Location: West Midlands, UK
Distribution: Slackware 14 (Server),OpenSuse 13.2 (Laptop & Desktop),, OpenSuse 13.2 on the wifes lappy
Posts: 781

Rep: Reputation: 98
New MariaDB as replacement for Mysql


Just upgraded to the latest and note the change log that says the MariaDB is a drop in replacement for Mysql.

What it doesn't say is when doing the upgrade, does Mysql get automatically removed in favour of MariaDB, or do I need to manually remove Mysql after upgrading.

So, does upgrading using slackpkg automatically just replace Mysql or not. Only asking as obviously the commands are the same from what I read, but pkgtool still shows Mysql as an installed pkg, and a bit concerned that if I remove Mysql, it will in fact remove MariaDB which uses the same directory structure etc.
 
Old 03-27-2013, 03:24 AM   #2
markush
Senior Member
 
Registered: Apr 2007
Location: Germany
Distribution: Slackware
Posts: 3,979

Rep: Reputation: Disabled
Quote:
Originally Posted by vdemuth View Post
Just upgraded to the latest and note the change log that says the MariaDB is a drop in replacement for Mysql.

What it doesn't say is when doing the upgrade, does Mysql get automatically removed in favour of MariaDB, or do I need to manually remove Mysql after upgrading.

So, does upgrading using slackpkg automatically just replace Mysql or not. Only asking as obviously the commands are the same from what I read, but pkgtool still shows Mysql as an installed pkg, and a bit concerned that if I remove Mysql, it will in fact remove MariaDB which uses the same directory structure etc.
Hi,

When you use slackpkg it will be removed automatically. Look at the changelogs
Code:
...
ap/mariadb-5.5.30-x86_64-1.txz: Added.
ap/mysql-5.5.29-x86_64-1.txz: Removed.
...
this is what slackpkg does. When you execute "slackpkg install-new" it adds mariadb and when you execute "slackpkg clean-system" it removes mysql. When you do it manually you will have to remove mysql with pkgtool or with removepkg.

BTW, you will not notice much of the change, the commands when using mysql remain the same.

Markus
 
1 members found this post helpful.
Old 03-27-2013, 04:00 AM   #3
chrisretusn
Senior Member
 
Registered: Dec 2005
Location: Philippines
Distribution: Slackware64-current
Posts: 2,969

Rep: Reputation: 1548Reputation: 1548Reputation: 1548Reputation: 1548Reputation: 1548Reputation: 1548Reputation: 1548Reputation: 1548Reputation: 1548Reputation: 1548Reputation: 1548
To put it another way, if you run slackpkg properly;

slackpkg install-new
slackpkg upgrade-all
slackpkg clean-system

Then mysql will be removed.
 
Old 03-27-2013, 11:01 AM   #4
vdemuth
Member
 
Registered: Oct 2003
Location: West Midlands, UK
Distribution: Slackware 14 (Server),OpenSuse 13.2 (Laptop & Desktop),, OpenSuse 13.2 on the wifes lappy
Posts: 781

Original Poster
Rep: Reputation: 98
Yeah, get that. But: Slackpkg install-new followed by slackpkg upgrade-all does the new installing and upgrading as expected. Issuing slackpkg clean-system, or indeed a manual removepkg, what happens to those files that appear with the same name and location in both packages. For instance, removeing Mysql will remove /usr/libexec/mysqld which appears in both packages with the same name and location along with many others.
Just looking for a definitive answer really, but willing to give it a shot. After all, the worst it can do is screw up my installation
 
Old 03-27-2013, 11:23 AM   #5
Mike_M
Member
 
Registered: Mar 2011
Location: California
Distribution: Slackware
Posts: 116

Rep: Reputation: 53
This is from the removepkg man page:

Quote:
When deleting files, removepkg will analyze the contents of the other packages installed on your system, and will only
delete the files that are unique to the package being removed. Similarly, the installation scripts for all the other
packages will be considered when deciding whether or not to delete symbolic links from the package.
 
Old 03-27-2013, 11:34 AM   #6
markush
Senior Member
 
Registered: Apr 2007
Location: Germany
Distribution: Slackware
Posts: 3,979

Rep: Reputation: Disabled
removepkg checks all dependencies. A file is deleted if it only belongs to the package which is removed. That's what removepkg says when it is executed. I suppose that slackpkg also uses removepkg when you run "clean-system".

Markus
 
Old 03-30-2013, 01:49 AM   #7
vdemuth
Member
 
Registered: Oct 2003
Location: West Midlands, UK
Distribution: Slackware 14 (Server),OpenSuse 13.2 (Laptop & Desktop),, OpenSuse 13.2 on the wifes lappy
Posts: 781

Original Poster
Rep: Reputation: 98
Well, done as suggested and it seems that MariaDB may not be a drop in replacement after all. Had to revert to mysql in oder for kmail to keep working. It seems that using Mariadb prevents Akonadi from running due to a missing database driver, namely QMYSQL.
Am happy to go back to MariaDB if anyone has a solution.

Last edited by vdemuth; 03-30-2013 at 01:58 AM.
 
Old 03-30-2013, 03:41 AM   #8
markush
Senior Member
 
Registered: Apr 2007
Location: Germany
Distribution: Slackware
Posts: 3,979

Rep: Reputation: Disabled
Quote:
Originally Posted by vdemuth View Post
Well, done as suggested and it seems that MariaDB may not be a drop in replacement after all. Had to revert to mysql in oder for kmail to keep working. It seems that using Mariadb prevents Akonadi from running due to a missing database driver, namely QMYSQL.
Am happy to go back to MariaDB if anyone has a solution.
Did you perform a complete upgrade of the packages in the changelogs from March 23? there was also l/akonadi upgraded.
Probably you should rebuild the packages which don't run properly.

Markus
 
Old 03-30-2013, 08:59 AM   #9
jtsn
Member
 
Registered: Sep 2011
Posts: 922

Rep: Reputation: 480Reputation: 480Reputation: 480Reputation: 480Reputation: 480
Quote:
Originally Posted by markush View Post
removepkg checks all dependencies. A file is deleted if it only belongs to the package which is removed.
That is BTW an unique and powerful feature, which AFAIK is only available in Slackware. And it only works, because there is no dependency tree to obey.
 
Old 03-30-2013, 10:56 AM   #10
vdemuth
Member
 
Registered: Oct 2003
Location: West Midlands, UK
Distribution: Slackware 14 (Server),OpenSuse 13.2 (Laptop & Desktop),, OpenSuse 13.2 on the wifes lappy
Posts: 781

Original Poster
Rep: Reputation: 98
Quote:
Originally Posted by markush View Post
Did you perform a complete upgrade of the packages in the changelogs from March 23? there was also l/akonadi upgraded.
Probably you should rebuild the packages which don't run properly.

Markus
Yep. Been diligently keeping upgraded. Including the 23rd/25th/27th and 28th.

I'll try a reinstall of akonadi first before attempting a rebuild.
 
Old 03-31-2013, 09:05 AM   #11
vdemuth
Member
 
Registered: Oct 2003
Location: West Midlands, UK
Distribution: Slackware 14 (Server),OpenSuse 13.2 (Laptop & Desktop),, OpenSuse 13.2 on the wifes lappy
Posts: 781

Original Poster
Rep: Reputation: 98
OK, a re-install of akonadi did the trick. I'll mark this one solved. Thanks to all that offered assistance.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Replace MySQL with MariaDB in Slackware abesirovic1 Slackware 36 03-28-2013 08:53 AM
LXer: Fedora Will Indeed Replace MySQL With MariaDB LXer Syndicated Linux News 0 02-05-2013 09:10 AM
LXer: Fedora 19: MariaDB instead of MySQL, but no Btrfs LXer Syndicated Linux News 0 02-01-2013 10:10 AM
LXer: Wikipedia moving from MySQL to MariaDB LXer Syndicated Linux News 0 12-17-2012 10:42 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware

All times are GMT -5. The time now is 05:42 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration