Large MySQL Database Backup, Restoration, & Offsite Storage at DropBox

Google AdSense

On Monday, my website host’s (DreamHost) database server crashed and they restored the previous week’s data for all of the databases hosted on that server. Eventually, they were able to restore the daily backups to disk, which allowed users to restore that day’s backup. However, when I went to restore the daily backup, it was about 16 hours old.

Within those 16 hours, one forum had hundreds of posts, topics, and forum reorganization; another WordPress blog had two dozen of posts; while my personal blog (this site) had no changes. At the time, my backup scheduled was:
Continue reading

How to remove passwords from protected Microsoft Word documents

Google AdSense

There’s always been a need to remove passwords from protected Microsoft Word documents when you need to make a change. My most common occurrence is with Human Resource (HR) forms. HR staff will create the MS Word document, password protect it, and then upload it to our company intranet. However, when I need to fill the form out, the only way to do so is to print the form, sign my name, scan the signed & printed form, and them email it back to them. What I would like to do, is to just paste a scan of my signature onto the form, save as a PDF, and them email them the PDF saving printing and scanning time and paper (which would then need to be shredded).

Here’s a trick that I learned a long time ago.
Continue reading

SubSonic 3.0

I’ve used SubSonic 2.x for a while and I’ve blogged about how useful it was as a tool to aid my development projects. A few weeks ago, SubSonic 3.0 was released and I hadn’t spent much time reviewing the updates and changes to version 3.0 until this week.

At the present, I have several large projects using SubSonic 2.x and I have a new smaller project starting this week. So I decided to download and install SubSonic 3.0 and use the small project to get familiar with the updates prior to updating my other web sites from 2.x to 3.0.

Continue reading

How to merge pages from a PDF document

A few months ago, I wrote a small article about extracting pages from a PDF document to create a new PDF document. This article will use the same library, iTextSharp, to merge pages from one PDF document to create a second PDF document.

For this utility, imagine having a PDF document with pages that are 8 1/2″ x 11″ and you want to combine 2 pages into one larger page. The resulting output document would be 17″ x 11″ and show two pages from the input document on one page on the output document.

Continue reading