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