Timeline for MariaDB ignores binlog_format
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 21, 2016 at 23:32 | vote | accept | Allan Araújo | ||
| Jan 21, 2016 at 23:32 | comment | added | Allan Araújo | UPDATE: I'm dumb. I forgot to delete the # before the binlog_format in the my.cnf. now it works just fine. | |
| Jan 20, 2016 at 5:04 | comment | added | Rick James |
Adding --defaults-file /etc/mysql/my.cnf to the script that invoked that may be a solution. Or, perhaps it is expecting it at /etc/my.cnf.
|
|
| Jan 20, 2016 at 3:36 | comment | added | Allan Araújo | usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --skip-log-error --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 | |
| Jan 20, 2016 at 3:15 | comment | added | Allan Araújo | So what the basedir contains? I'm going to check the arguments, just a minute | |
| Jan 20, 2016 at 3:10 | comment | added | Rick James |
What arguments are on the running mysqld service?
|
|
| Jan 20, 2016 at 3:10 | comment | added | Rick James |
my.cnf is a text file that contains configuration settings for MySQL or MariaDB.
|
|
| Jan 20, 2016 at 3:03 | comment | added | Allan Araújo | I also did think that /etc/mysql is a very strange place fot a basedir, but here is what my /usr folder contains: bin games include lib local sbin share src And my /etc/mysql folder: conf.d debian.cnf debian-start my.cnf I did also spin up a new VPS and installed only MariaDB again from scratch, same thing happens. Logging out and back in, restarting the service, restarting the server, nothing did make the options stick, even with the my.cnf still saying "row". | |
| Jan 20, 2016 at 2:51 | history | answered | Rick James | CC BY-SA 3.0 |