LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Suse/Novell
User Name
Password
Suse/Novell This Forum is for the discussion of Suse Linux.

Notices

Reply
 
Search this Thread
Old 04-17-2013, 06:24 AM   #1
sniff
Member
 
Registered: Jan 2003
Location: Durham UK
Distribution: openSUSE 12.2/3 x86_64, Debian
Posts: 313

Rep: Reputation: 42
Question Opensuse 12.3 MySQL


Hello,

I don't want to make the change away from MySQL. I write a lot of programs that interface with databases directly and I don't know how they would behave with MariaDB. If anyone knows how C++ and Java interface with MariaDB I would be interested to hear.

I want to tweak the config of the MySQL database at startup. Where is the config now. Is it still /etc/my.cnf? It says not to edit the file at the top? I assume that it would be ok to edit this file and it will not be over written by an update?

Cheers,
Phil
 
Old 04-17-2013, 09:32 AM   #2
Boucane
LQ Newbie
 
Registered: Dec 2008
Location: Montreal
Distribution: Suse 11.0
Posts: 8

Rep: Reputation: 2
You can place my.cnf in your home directory
 
Old 04-17-2013, 10:25 AM   #3
sniff
Member
 
Registered: Jan 2003
Location: Durham UK
Distribution: openSUSE 12.2/3 x86_64, Debian
Posts: 313

Original Poster
Rep: Reputation: 42
But the server starts at boot and should be running even if on one is logged in. Or do you mean just keep a copy safe in case it is over written?
 
Old 04-17-2013, 11:44 AM   #4
Boucane
LQ Newbie
 
Registered: Dec 2008
Location: Montreal
Distribution: Suse 11.0
Posts: 8

Rep: Reputation: 2
Maybe mysql home?

with a mysql --help cmd you will see the search path and order of the configuration file
"
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf
"

edit the file where ecer you want and keep a copy
 
1 members found this post helpful.
Old 04-17-2013, 11:48 AM   #5
sniff
Member
 
Registered: Jan 2003
Location: Durham UK
Distribution: openSUSE 12.2/3 x86_64, Debian
Posts: 313

Original Poster
Rep: Reputation: 42
Thanks that's very helpful, I didn't know that mysql --help listed the locations. I will put it in /etc/mysql/my.cnf as that seems like the most logical place (that directory already exists).

I will mark the thread solved.

Cheers,
Phil
 
  


Reply

Tags
config, mysql, opensuse


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
Cannot compile mysql 5.6-10 server on opensuse 12.1 aliga8er Linux - Newbie 3 04-09-2013 12:53 AM
LXer: OpenSUSE also considers switching from MySQL to MariaDB LXer Syndicated Linux News 0 01-23-2013 11:11 PM
OpenSUSE 11.1 + Freeradius + mysql (problem with mysql) JamesWhetherly Linux - Networking 1 09-03-2009 03:10 AM
MySQL on openSuse 10.3 clmowers Linux - Software 4 10-19-2007 08:31 AM
MySQL setup openSuSE 10.2, no super user? Enil8 Linux - Software 2 05-25-2007 10:03 AM


All times are GMT -5. The time now is 07:55 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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration