This is a pretty cool deal this will scan your email and let you know what your biggest email culprits are as far as size is concerned. Since I stopped deleting my email in Gmail my inbox was growing pretty large. Well this is a way to let you know where the big emails are and remove them. After running this service I went from 20% space use to 5% space use and that was just deleting the Ultra big emails. What it does is scans your emails and then adds labels to them so you can identify your big emails. This is a great way to clean out your inbox quickly. All you do is go to FindBigMail.com and let her rip!
Tag Archive: automation
Well I am always trying to find a way to automate my backups. So I already have my webserver setup to run a cpanel automated backup on Monday’s, after a little script change to handle the new LunarPages theme ‘LP3′ and now I wrote a little batch file to push the most recent backup to my Dropbox account. This way I have an offsite backup of my website as well. The script to get the most recent file is pretty straight forward but it did take me a while to figure it out:
–this Deletes the existing files
del/q “C:\Documents and Settings\Dan Murphy\My Documents\My Dropbox\*.tar.gz”
–this adds a pause for 45 seconds
ping -n 45 127.0.0.1 > NUL 2>&1
–this sets up the variables
set backupcmd=c:\windows\system32\xcopy.exe /c /d /e /h /r /y
set dt=%date:~7,2%.%date:~10,4%
–this runs the commnd
%backupcmd% “c:\source\”*%dt%*.tar.gz “C:\Destination”
I have setup my web hosting service to FTP my full backup of my website every Monday. While this automation is great I forgot about one thing to maintain. With each one of these backup files being about 1GB it can start to take up a lot of space if you do not clean up your older files!
So after searching around I came around the .vbs script that looks at the directory and deletes any file older than a specified number of days. In this case I have chosen 60 days. Now a few things to remember, make sure you keep backing up your site if you are running this file otherwise you will delete all of your backups if it is long than 60 days since your last backup! Using Windows scheduler I have made this run shortly after I receive my latest backup file from my web host. This makes my backup process totally automated now even for maintaining files!
Looks like I finally figured out how to automate cpanel backups. Since most of my sites are all hosted on the same account backup was a sinch with cpanel full backup. Only issue was that I could not automate the task until now!
First I setup my own local FTP so I had a remote place to put the files. Then using the script below edited it put in my cpanel variables and then created a cron job to run the file. The issue wasn’t finding this script, I have had it for a while, the issue was getting the darn thing to work. Looks like what I was missing was changing the $skin parameter to ‘lp’…thank you Lunar Pages Forum (yes should have looked there a long time ago but didn’t). Lunar Pages would be my host and looks like they have their own skin for cpanel. Once I got that in place everything worked perfectly and then I just scheduled the cron job below.
Here is the script cpanel_backup.php
Update: I had to make some minor changes to the file to include the remote directory and FTP port as I was getting errors saying all the forms were not filled out. Here is the latest version cpanel_backup.php Version 2
Then schedule the script job via Cron
0 0 * * 1 /usr/bin/env php cpanel_backup.php
I have had to do this a lot lately with all the database work I have been doing so I figured I would write this down before I forgot about it.
If you need to restore a database from a .sql file here is the command:
mysql -h hostname -u username -pthepassword databasename < dumpfile.sql
If you need to dump a database to a file (for automated backup purposes) you can use this command:
mysqldump -h hostname -u username -pthepassword databasename > backup-file.sql
These can be very helpful when doing database work
So I have decided to resurrect an old laptop that I had sitting in my office for about 2 years. Well after $40 to quadruple the memory and replacing the hard drive and then re-installing XP from scratch and then all the manufacturer drivers, we finally are in business. I then plugged this into my network and our LCD TV and the stereo. So it is our own little home entertainment system for our TV. Well I decided that since this thing would be on 24/7 that I needed to do some automation to some tasks to keep it clean. Because Playon and Hulu and other web based tools like to create awesomely large temp files that just hang around if you do not delete them. Also because it is a WindowsXP machine I figured scheduling a daily reboot wasn’t a bad idea either. Well turns out these are all very simple things to automate and then schedule.
For CCleaner you just need to run it in the silent mode by creating a schedule that kicks off ‘CCleaner /AUTO’
For JKDefrag you just need to schedule to run the JKDefragCMD file
For a scheduled reboot you just need to schedule a job that kicks off ‘Shutdown.exe -r -t 00′
Lifehacker has a great article on other processes you can automate but these were the first three I went after to keep my computer clean. I scheduled CCleaner and JKDefrag on my work laptop and it really does keep things clean and moving along a whole lot better!
