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…

Technology Insights

mysqldump

MYSQLDUMP(1) MySQL Database System MYSQLDUMP(1) NAME mysqldump – a database backup program SYNOPSIS mysqldump [options] [db_name [tbl_name …]] DESCRIPTION The mysqldump client is a backup program originally written by Igor Romanenko. It can be used to dump a database or a collection of databases for backup or transfer to another SQL server (not necessarily a…