bulk rename

It's very simple command, but I never used before [I was going to write a script for this req. :)]

[mandy@mandy mpix]$ ls *20121031000012*
mp1_20121031000012.txt  mp2_20121031000012.txt  mp3_20121031000012.txt

[mandy@mandy mpix]$ rename "20121031000012" "20121031000013" *20121031000012.txt

[mandy@mandy mpix]$ ls *20121031000013*
mp1_20121031000013.txt  mp2_20121031000013.txt  mp3_20121031000013.txt

Dealing with images??, get ImageMagick

I am using and playing a lot with the images in my current project. It involves heavy dealing with png's, jpg's and gif's like: merging, cutting, re-scaling and stuff.

There is a very cool library to deal with all these things : ImageMagick.

You can do pretty much anything with this.

You have extension available for PHP for imagemagick named as Imagick.( Perl also have an extension).

This could be a very good start if you are interested:
http://www.imagemagick.org/Usage/compose/

MySQL Security Best Practices

Very useful link for MySQL Security:

http://www.greensql.com/articles/mysql-security-best-practices