[SOLVED] Opensuse 12.3 MySQL

sniff · 04-17-2013, 05:24 AM

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

Boucane · 04-17-2013, 08:32 AM

You can place my.cnf in your home directory

sniff · 04-17-2013, 09:25 AM

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?

Boucane · 04-17-2013, 10:44 AM

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

sniff · 04-17-2013, 10:48 AM

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