This shows you the differences between two versions of the page.
| |
home_server:web_server_setup [2022-11-13 Sun wk45 10:36] – [mariadb binary log files] baumkp | home_server:web_server_setup [2023-04-30 Sun wk17 17:43] (current) – external edit 127.0.0.1 |
---|
*Nextcloud Stable Server Administration Manual [[https://docs.nextcloud.com/server/stable/admin_manual/maintenance/index.html|Maintenance]]. (This also discusses database management, backup and restore) | *Nextcloud Stable Server Administration Manual [[https://docs.nextcloud.com/server/stable/admin_manual/maintenance/index.html|Maintenance]]. (This also discusses database management, backup and restore) |
====mariadb binary log files==== | ====mariadb binary log files==== |
| The mysql binary log files are located here: ''var/log/mysql''. Some time they fill up the file system and the system then fails to operate. |
* ''sudo mysql -p -u root'' - Login in to mysql, need root password | * ''sudo mysql -p -u root'' - Login in to mysql, need root password |
* ''SHOW BINARY LOGS;'' - to list current binary log files | * ''SHOW BINARY LOGS;'' - to list current binary log files |
* ''%%show variables like "sql_log_bin";%%'' - to see current setting of variable ''%%"sql_log_bin"%%'' | * ''%%show variables like "sql_log_bin";%%'' - to see current setting of variable ''%%"sql_log_bin"%%'' |
* ''%%SET sql_log_bin = 0;%%'' - to set a variable | * ''%%SET sql_log_bin = 0;%%'' - to set a variable |
| * ''exit'' or ^d - to exit |
| |
---- | ---- |
====Nextcloud OCC Comand==== | ====Nextcloud OCC Comand==== |