838292 - Please restore the Mozillians staging database

Status: RESOLVED FIXED

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

Description

[Justin Crawford [:hoosteeno] [:jcrawford]]

We pushed a bad migration to staging on Feb 01 2013 06:42:25. Could you restore the Mozillians staging database to sometime earlier that day or late the previous day?

I did not give this an extreme severity, but there are a few of us really hoping that we can get it done today. TIA!

Comment 1

[Sheeri Cabral [:sheeri]]

Will start this now, thanx for the heads-up on IRC.

Comment 2

[Sheeri Cabral [:sheeri]]

Imported to the mozillians_stage database. Please verify or reopen as needed.

Comment 3

[Justin Crawford [:hoosteeno] [:jcrawford]]

Thanks for the quick fix!

Comment 4

[Giorgos Logiotatidis [:giorgos]]

Can you please drop all tables and re-import the same backup? Tables introduced by the bad migration still exist and are blocking us from pushing to stage.

Thanks!

Comment 5

[Sheeri Cabral [:sheeri]]

Done. For my records:

[[e-mail]1 ~]# mysql -e "drop database mozillians_stage; create database mozillians_stage;"
[[e-mail]1 ~]# mysql mozillians_stage < /home/scabral/mozillians_stage.2013.02.02.sql 
[[e-mail]1 ~]#

Comment 6

[Justin Crawford [:hoosteeno] [:jcrawford]]

will the 2/2/13 backup be early enough? the bad migration was on 2/1...

Comment 7

[Sheeri Cabral [:sheeri]]

Just updating with the final info - the 2/2 backup actually is the 1/30 backup - we had a replication problems.

also kudos to :sancus who pointed out that that backup had myisam tables. I fixed the export to have only innodb tables and dropped & reacreated & reimported the data.

All is well!