Removing Old MySQL Binary Logs
Came across a server with MySQL crashing. It was a master server that replicates to a slave. It was out of drive space as there were a ton of these: -rw-rw---- 1 mysql mysql 1073795569...
The only one that seems to be having fun.
Came across a server with MySQL crashing. It was a master server that replicates to a slave. It was out of drive space as there were a ton of these: -rw-rw---- 1 mysql mysql 1073795569...
Quick example on removing blank lines from a file for future reference: # cat testfile.txt line1 line2 line3 line4 line5 line6 # sed '/^$/d' -i testfile.txt # cat testfile.txt line1 line2 line3 line4 line5 line6
So far I've found for CentOS and RedHat you just need to get a listing of the directory /dev/disk/by-uuid/ as shown here: [root@uno vhosts]# ls -l /dev/disk/by-uuid/ total 0 lrwxrwxrwx 1 root root 9 Jan...
Linux: Sort du -h (human-readable) Output By Size. Useful for sorting files by size in human-readable. Nice when used in conjunction with Finding large files and then sorting them by actual size.
What happened?!? When the Plesk "admin" user breaks, the panel breaks. This is often an issue when the "admin" password stored in /etc/psa/.psa.shadow does not match what the "admin" password is in MySQL. Of course,...
Using grep to find hacked files on a website should be quick and easy and give you a nice list of files that all have the hacked code to the pages. I ran across a...
Receiving the following when trying to restart apache (httpd): [root@localhost ~]# service httpd restart Stopping httpd: [FAILED] Starting httpd: Syntax error on line 31 of /etc/httpd/conf.d/php.conf: Invalid command 'php_value', perhaps misspelled or defined by a...
Deprecated -- This will back up ALL MySQL databases. I'll have a new one out soon. === Here's a script I've put together to run nightly database dumps. There's a lot of back up software...