652147 - DB Tweak on markup staging

Status: VERIFIED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Fred Wenzel [:wenzel]]

We need to remove some invalid data from Markup.allizom's staging database (bug 651921).

Please run:

DELETE FROM `markup_mark` WHERE `points_obj_simplified` LIKE 'bnVsbA==%'


Thanks.

Comment 1

[Jake Maul [:jakem]]

Completed.

[root@tm-stage01-master01 ~]# mysql
mysql> \u markup_allizom_org
mysql> select * from markup_mark where points_obj_simplified like 'bnVsbA==%';
<snip>
6 rows in set (0.26 sec)
mysql> DELETE FROM `markup_mark` WHERE `points_obj_simplified` LIKE 'bnVsbA==%';
Query OK, 6 rows affected (0.03 sec)

Comment 2

[Fred Wenzel [:wenzel]]

Thanks, Jake!

Comment 3

[Matt Brandt [:mbrandt]]

Thanks Jake and Wenzel!