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 […]
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 […]
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 […]
You will then need to ensure the module is enabled: Then restart Apache to load the new modules:
