Blog

Swapping Column Values in MySQL

If you ever need to swap column values in MySQL here is how: UPDATE TABLE s1, TABLE s2 SET s1.SWAP_A=s1.SWAP_B, s1.SWAP_B=s2.SWAP_A WHERE s1.KEY=s2.KEY Check out this article to read more.
Read more

FTP using WordPress and Amazon Web Services

Recently I started using Amazon Web Services for hosting and what not... some way cool stuff there.  Something I immediately ran into was this problem: When I installed WordPress I could NOT install any plugins and/or updates, through the WordPress interface because it would not let me use SSH2 with my PEM key that AWS…
Read more

Cannot change permissions when selecting multiple folders

Wow, just found this out.  So now if you have Windows 7 OR Server 2008 or above you can't change folder/file permissions when selecting multiple folders... read more about it.  I'll update if there is a GOOD solution. Update: Apparently it was purposely removed, according to this thread in the Server forums... http://social.technet.microsoft.com/Forums/en/winserverfiles/thread/dbfa011b-7c27-4e1d-b1a4-f0f8839b2d46
Read more

Batch rename file extensions

Simple but can be very useful. Open up a command prompt Go the file folder containing the files you need to rename Enter this: ren *.(current extension name) *.(extension you want) If done correctly it will rename all the file extensions to the specified one! Example: ren *.jpg *.png <<< this will rename all jpg…
Read more

Backscatterer Network Spam List

Has your e-mail server ever been blacklisted? Or are you getting rejected emails?  A good first step is to check MxToolBox too see if you ARE indeed blacklisted.  Now, if you see one called "Backscatterer.org" you are in trouble, read this to see why. Basically, "As it turns out Backscatterer is NOT a blacklist, It's…
Read more