840071 - Get rid of old MySQL support_stage_mozilla_com database on stage in scl3

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Sheeri Cabral [:sheeri]]

Brandon discovered on Friday that support_stage_mozilla_com on stage in scl3 is an old version:

MariaDB [support_stage_mozilla_com]> select * from schema_version;
+---------+
| version |
+---------+
|     142 |
+---------+
1 row in set (0.00 sec)

So let's decomission it.

Comment 1

[Sheeri Cabral [:sheeri]]

on stage1.db.scl3 in /root/archive:

[root@stage1 archive]# mysqldump support_stage_mozilla_com > support_stage_mozilla_com.sql

Comment 2

[Sheeri Cabral [:sheeri]]

[root@stage1 archive]# gzip support_stage_mozilla_com.sql
[root@stage1 archive]# ls -lrth support*
-rw-r--r-- 1 root root 456M Feb 11 07:28 support_stage_mozilla_com.sql.gz
[root@stage1 archive]# 

Database dropped:

[root@stage1 archive]# mysql -e "drop database support_stage_mozilla_com"
[root@stage1 archive]#