Technology Insights

WordPress mysqldump Backup Corrupted Because of Blob Fields in Angsuman’s Translator Plugin Pro MySQL Tables

During a recent WordPress upgrade I was performing I noticed an issue with the mysqldump of the WordPress database which was causing the actual .sql file backup of the database to not read properly. After investigating I noticed that the atpp_page_cache table from Angsuman’s Translator Plugin Pro included Blob columns that were not dumping properly with the default mysqldump syntax as shown below.

bash

  1. mysqldump -u root -p databasename > db_backup_file.sql

Technology Insights

How to Create Photo Albums On Your iPhone On A Windows XP Computer

Creating Photo Albums on your iPhone is not really straight forward so below I will describe numerous ways to organize images on your iPhone. You can use third party applications to organize folders and images or you can use the built in Photo Album functionality. Below I describe how to use either method including tips on what to watch out for and allow you to make an educated decision on the best way to manage your images.