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
Move shared folders and retain file and share permissions with robocopy
If you have ever had to move files from one server to another (or even computer to computer).... you NEED to use ROBOCOPY. It is a built in Windows tool, simple to use and way faster than "drag and drop". I originally asked the above question on SpiceWorks and wanted to share what I found…
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