Hi Nicholas! Thanks so much for pointing me in the right direction.
Two plugins were causing the problem on my WordPress site.
. WP Google Maps - WP Google Maps – WordPress plugin | WordPress.org
- Wordfence - WordPress Security Plugin | Wordfence
Neither Plugin was being used, so I deleted the plugins, manually removed the associated MYSQL tables, and I was then able to backup and restore the website without error.
Here is an example of the offending data in one of the tables.
DROP TABLE IF EXISTS `wpac_wpgmza`;
CREATE TABLE `wpac_wpgmza` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`map_id` int(11) NOT NULL,
`address` varchar(700) NOT NULL,
`description` mediumtext NOT NULL,
`pic` varchar(700) NOT NULL,
`link` varchar(2083) NOT NULL,
`icon` varchar(700) NOT NULL,
`lat` varchar(100) NOT NULL,
`lng` varchar(100) NOT NULL,
`anim` varchar(3) NOT NULL,
`title` varchar(700) NOT NULL,
`infoopen` varchar(3) NOT NULL,
`category` varchar(500) NOT NULL,
`approved` tinyint(1) DEFAULT 1,
`retina` tinyint(1) DEFAULT 0,
`type` tinyint(1) DEFAULT 0,
`did` varchar(500) NOT NULL,
`other_data` longtext NOT NULL,
`latlng` point DEFAULT NULL,
`sticky` tinyint(1) DEFAULT 0,
`lnglat` point NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
INSERT INTO `wpac_wpgmza` VALUES (1,1,"12345 E High Road, Suite 50, Denver, CO 99999","","","","","39.111111","-104.231111",0,"",0,0,1,0,0,"","","\0\0\0\0\0\0\0×ÜÑÿr‡C@…—àÔ6ZÀ",0,"");
David
