LinuxQuestions.org
Review your favorite Linux distribution.
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 04-14-2014, 12:40 AM   #1
kikinovak
Senior Member
 
Registered: Jun 2011
Location: Montpezat (South France)
Distribution: Slackware, Slackware64
Posts: 1,622

Rep: Reputation: 759Reputation: 759Reputation: 759Reputation: 759Reputation: 759Reputation: 759Reputation: 759
Setting up MySQL/MariaDB under Slackware 14.1


Hi,

All my servers are running Slackware 14.0 (or 13.37) for now. I'm considering migrating them to Slackware 14.1. I know MySQL has been replaced by MariaDB, which is supposed to be compatible. But as far as I can tell, the initialization routine has changed.

Here's my documentation for MySQL under 14.0:

http://www.microlinux.fr/slackware/L...ySQL-HOWTO.txt

This doesn't seem to work anymore. Anybody knows where I can find a reliable quick-and-dirty (or thorough-the-hard-way) HOWTO to setup MariaDB under Slackware 14.1 ?

Cheers,

Niki
 
Old 04-14-2014, 12:48 AM   #2
kikinovak
Senior Member
 
Registered: Jun 2011
Location: Montpezat (South France)
Distribution: Slackware, Slackware64
Posts: 1,622

Original Poster
Rep: Reputation: 759Reputation: 759Reputation: 759Reputation: 759Reputation: 759Reputation: 759Reputation: 759
OK, here's what I could figure out for now.

1. All the my-small.cnf, my-medium.cnf, ... files in /etc/mysql have gone. Apparently there's no replacement for these. Correct me if I'm wrong.

2. Everything else seems to work as before.

3. When I log in to the database monitor using mysql -u root -p, I get the following console:

Code:
MariaDB [(none)]>
If I understand this right, MariaDB shows me the currently selected database.

4. Any other surprises to be expected?
 
Old 04-14-2014, 02:15 AM   #3
Alien Bob
Slackware Contributor
 
Registered: Sep 2005
Location: Eindhoven, The Netherlands
Distribution: Slackware
Posts: 5,259

Rep: Reputation: Disabled
Note that there will now be a "/etc/my.cnf" file which includes all the configuration files in a directory "/etc/my.cnf.d/" which contains different server- and client-focused configurations (by default, they are empty as far as I know).

Eric
 
Old 04-15-2014, 02:49 AM   #4
ppr:kut
Member
 
Registered: Aug 2006
Location: Netherlands
Distribution: Slackware
Posts: 361

Rep: Reputation: 93
Quote:
Originally Posted by kikinovak View Post
3. When I log in to the database monitor using mysql -u root -p, I get the following console:

Code:
MariaDB [(none)]>
If I understand this right, MariaDB shows me the currently selected database.
That's just the prompt, which is pretty much as configurable as your shell prompt. MariaDB just changed the default to, as you correctly stated, show the name of the database you are currently using.
 
Old 04-15-2014, 03:44 AM   #5
ppr:kut
Member
 
Registered: Aug 2006
Location: Netherlands
Distribution: Slackware
Posts: 361

Rep: Reputation: 93
Most of the incompatibilities should be listed at https://mariadb.com/kb/en/mariadb-ve...compatibility/.
New features only available in MariaDB are listed at https://mariadb.com/kb/en/mariadb-ve...ysql-features/

Note that the configuration file changes are just structural. Nothing prevents you from copying your old my.cnf file over and completely ignoring /etc/my.cnf.d.
 
Old 04-15-2014, 06:59 AM   #6
piacentini
LQ Newbie
 
Registered: May 2013
Posts: 12

Rep: Reputation: Disabled
My experience here with several php-based applications is that the switch is really transparent. All tools and scripts continue to work as they did with MySQL 5.5. YMMV, of course, but I would not expect problems.
 
Old 04-15-2014, 08:06 AM   #7
tronayne
Senior Member
 
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,043

Rep: Reputation: 763Reputation: 763Reputation: 763Reputation: 763Reputation: 763Reputation: 763Reputation: 763
When I installed 14.1, there were no problems with existing MySQL data bases (or LAMP applications), everything "just works." I was busy with other stuff and didn't even look at the .cnf files. Did have to fiddle with HTTP (a little, it changed) but, so far, no problems.

Hm; maybe I've got to get on the stick and see if I can break something, eh?
 
  


Reply

Tags
mariadb, mysql


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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
Keep using MySQL instead of MariaDB kelaskakap Slackware 17 12-13-2013 06:43 PM
MariaDB/MySQL uses too much RAM martvefun Linux - Server 3 06-23-2013 08:50 AM
[SOLVED] New MariaDB as replacement for Mysql vdemuth Slackware 10 03-31-2013 09:05 AM
Replace MySQL with MariaDB in Slackware abesirovic1 Slackware 36 03-28-2013 08:53 AM
[SOLVED] Slackware: Replace MySQL with MariaDB on fresh installation. astanton Slackware 4 03-03-2012 02:37 AM


All times are GMT -5. The time now is 02:02 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration