Category: Linux

MySQL move BIN files location

Change MySQL Binary Log File Location To Another Directory Follow the below steps to change MySQL binary log file location to another directory. 1. Edit the log-bin variable in my.cnf file located in /etc/my.cnf to log-bin=/new/directory/path/mysql-bin . # vi /etc/my.cnf …… ……… log-bin=/new/directory/path/mysql-bin ….. ……. Save and close the file. 2. To minimize the number of moved files, purge […]

Read More »

Posted in %1$s

Crontab

Cron Schedule Syntax A basic crontab entry looks something like this: https://crontab.guru/ – this is just an awesome site to get the entry for a specific schedule. Managing Crontab Entries Once cron is running, it checks for crontab entries in the following files every minute: The first file, /etc/crontab, is a system-generated file containing shortcut commands […]

Read More »

Posted in %1$s

MySQL Purge BIN files

Do not delete the files from the file system. MySQL will complain at some time in the future. Save yourself the unnecessary downtime by using PURGE BINARY LOGS command from within MySQL or Change automatic default purge expiry from 30days (default) For long term set the BIN logs to a shorter time frame 1 day mysql> SET […]

Read More »

Posted in %1$s

Mysql not creating PID file

ls /var/run/mysqld/ – should show below If not sudo service mysql stop sudo service mysql start Oddly the following has happened to me, I do not know why and am not really phased. Do not be in the folder /var/run/mysqld when doing the restart this for what ever reason has ended with none of the […]

Read More »

Posted in %1$s

Linux Screen

The short version that you need, the rest is nice to know but this is your bread and butter. screen (starts a new session) this is once off until you destroy it or server/system restart. CTRL+A (then release both) then press D will put the session into the back. screen -r (will reconnect you to […]

Read More »

Posted in %1$s Tagged %1$s

The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY

Ubuntu The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY B53DC80D13EDEF05 GPG error: http://packages.cloud.google.com/apt google-cloud-monitoring-focal-all InRelease: The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY B53DC80D13EDEF05 i.e. for this specific key “B53DC80D13EDEF05” being reported Run the following command Executing: /tmp/apt-key-gpghome.5ZVvtULX98/gpg.1.sh –keyserver hkp://keyserver.ubuntu.com:80 –recv-keys B53DC80D13EDEF05gpg: key […]

Read More »

Posted in %1$s

Linux Server Security Tips and Best Practices

checklist for SysAdmins This article includes a collection of commands and best practices that you can use to improve the security of your Linux servers (RHEL/CentOS) 1. Remove insecure tools (FTP, telnet, rlogin, rsh, etc.) and use only secure alternatives (SCP, SSH, sftp, rsync, etc.) When choosing data communication tools, use only the secure and […]

Read More »

Posted in %1$s
Theme by Flythemes
x  Powerful Protection for WordPress, from Shield Security
This Site Is Protected By
Shield Security