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

You can place my.cnf in your home directory

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?

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

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