Dino Geek, try to help you

How to disable binary logging in MariaDB?


To disable binary logging in MariaDB, you need to edit your MariaDB configuration file that typically can be found in one of the following directories `/etc/mysql/`, `/etc/mysql/mariadb.conf.d/` or in `/etc/my.cnf`.

Here are the steps:

1. Open your MariaDB configuration file with a text editor, for example, using the `nano` command in the terminal:

```
sudo nano /etc/mysql/my.cnf
```

1. Find the `mysqld` section and look for a line that contains `log_bin`. If the line is present, comment it out by putting a `#` symbol in front of it.

1. If the line `log_bin` is not present or already commented out, binary logging is probably disabled but to be sure you can add the following line in the `mysqld` section:

```
skip-log-bin
```

1. Now, save your changes and close the text editor:
- In `nano` press `Ctrl + X`, then `Y`, and then `Enter`.

1. Restart your MariaDB service for changes to take effect.

```
sudo systemctl restart mariadb
```

Remember, if you are going to replicate your databases or if you want to be able to recover your databases to a certain point, you should enable binary logging. Disabling binary logging will also disable the possibility to use point-in-time recovery and can limit the effectiveness of backups and replicas.


Simply generate articles to optimize your SEO
Simply generate articles to optimize your SEO





DinoGeek offers simple articles on complex technologies

Would you like to be quoted in this article? It's very simple, contact us at dino@eiki.fr

CSS | NodeJS | DNS | DMARC | MAPI | NNTP | htaccess | PHP | HTTPS | Drupal | WEB3 | LLM | Wordpress | TLD | Domain name | IMAP | TCP | NFT | MariaDB | FTP | Zigbee | NMAP | SNMP | SEO | E-Mail | LXC | HTTP | MangoDB | SFTP | RAG | SSH | HTML | ChatGPT API | OSPF | JavaScript | Docker | OpenVZ | ChatGPT | VPS | ZIMBRA | SPF | UDP | Joomla | IPV6 | BGP | Django | Reactjs | DKIM | VMWare | RSYNC | Python | TFTP | Webdav | FAAS | Apache | IPV4 | LDAP | POP3 | SMTP

| Whispers of love (API) | Déclaration d'Amour |






Legal Notice / General Conditions of Use