962311 - [sumomo] MySQL database dump for SUMO migration from SUMOMO Q12014

Status: RESOLVED FIXED

(support.mozillamessaging.com Graveyard :: Knowledge Base Articles, defect)

Description

[Roland Tanglao needinfo please :rolandtanglao, :mohnkuchen, :adobo, :sinigang, :roland]

+++ This bug was initially created as a clone of Bug #754439 +++

Hi Gozer:

just like bug 754439 please provide:

1. a sumomo db dump

2. a dump of sumomo kb articles media (images and videos)
NB: we will have to do this 3 times or more (for testing and migration scripting purposes so if you could make this doable or give :ricky et al in Sumo dev a script to do this that would be most appreciated)

Comment 1

[Philippe M. Chiasson (:gozer)]

/usr/local/bin/dump-sumomo script created and can be run as root, the results are dumped in the current directory:

- sumomo-db.20140122.sql.gz
- sumomo-uploads.20140122.gz

Comment 2

[Roland Tanglao needinfo please :rolandtanglao, :mohnkuchen, :adobo, :sinigang, :roland]

:gozer, awesome, thanks, can you attach the dump and the script to this bug or put it on Mozilla's google docs instance? sumo-dev doesn't have credentials to get the dump

AND OR  :sancus can you figure something out for sumo-dev so we don't have to keep bothering gozer?

Comment 3

[Roland Tanglao needinfo please :rolandtanglao, :mohnkuchen, :adobo, :sinigang, :roland]

dump was provided to :mythmon by sancus and gozer (thanks to G and S) so clearing needinfo!