Stuff…

This looks like a useful mysql tuning script:

http://blog.mysqltuner.com/

Otherwise the mysql.com pages are good for tuning:

http://dev.mysql.com/doc/refman/5.0/en/optimization.html
http://dev.mysql.com/doc/refman/5.1/en/optimization.html

[Read more →]

This site was useful when wanting to check some obfuscated PHP scripts.  Pesky spammers have a habit of using base64_decode in dodgy php scripts to try and stop you from finding out what they are doing/executing.
URL:
Online base64_decode() function – By Tools 4 Noobs. :-)

[Read more →]

It appears that the Plesk backup utility (pleskbackup Linux) writes to a temporary file prior to moving it to the final destination you’ve specified on the command line.
ie. When running:
/usr/local/psa/bin/pleskbackup all /mnt/nfsshare/pleskbackup.bak
Plesk writes the whole backup file to the local disk in /var/lib/psa/dumps/tmp/:
# ls -lah /var/lib/psa/dumps/tmp/
total 1.9G
drwx—— 2 psaadm psaadm 4.0K 2009-02-09 18:38 .
drwxr-xr-x 3 [...]

[Read more →]

I was getting a bit bored of manually testing SMTP AUTH details for people so wrote a quick little script in perl (with help of modules) to test.
#!/usr/bin/perl -w
use Net::SMTP_auth;
use Getopt::Std;
%options=();
getopts(“u:p:h:”,\%options);
my $_USAGE= <<END_USAGE;
test_auth.pl   -  Check SMTP authentication
Usage:   test_auth.pl -u user -p pass -h hostname
License: This software is released under the same terms as perl itself.
END_USAGE
die [...]

[Read more →]

How to remove ^M from within a file:

perl -pi -e ‘y/\015//d’filename

[Read more →]