578484 - Need a daily db dump davedash's home directory from input.mozilla.com db

Status: RESOLVED FIXED

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

Description

[Aakash Desai [:aakashd]]

Per Dave Dash's request, we'd like a daily db dump from input.mozilla.com db onto Dave Dash's home directory on khan. 

Side request: can it be mirrored to cm-webdev-01 ?

We'd like to get this done today if possible. If not today, then as soon as you can.

Comment 1

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

Daily dump isn't necessary if we can get this on cm-webdev-01, then I can dump from there as needed.

Comment 2

[Aakash Desai [:aakashd]]

Can we get an update on this because it's a priority to get feedback better understood for the Firefox Beta program.

Comment 3

[Aakash Desai [:aakashd]]

Ping again? We have metrics, webdev and Tomcat waiting for this.

Comment 4

[Anurag Phadke[:[e-mail]]]

I was able to copy 2 days dump from dave's home folder to my local folder.
see attached file if anyone wants the data.
ideally, we want an automated way to get the daily dumps.

Comment 5

[Anurag Phadke[:[e-mail]]]

Attachment: sample data from dd's home folder

Comment 6

[Fred Wenzel [:wenzel]]

Just feed a copy daily into a DB on cm-webdev01-master01. We do that for AMO, so if you find out where that happens and who set it up (oremj?) you can yank it.

Comment 7

[timellis]

Done. The backup will go to cm-webdev01-master01. If you need some data today and can't get access to it, let me know, I'll do a one-off job to get the data to you.

Also, if you don't see the input_mozilla_com database appear tomorrow as like all the other databases, let me know.

Comment 8

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

Not seeing it - if you can do a one-off today, and then see why it's not coming through that'd be great.

Comment 9

[timellis]

Is it because I'm root? If you try to repro the following output, what error or bizarro output do you get?

[root@cm-webdev01-master01 15:25:27 /mnt/eql-vol1/backup-drop/c01/mysql]
:) ls -l input_mozilla_com/
-rw-r--r--  1 root root       0 Jul 19 10:11 drop-complete
-rwx------  1 root root 8047098 Jul 15 08:05 input_mozilla_com.2010.07.15.sql.gz
-rwx------  1 root root 8412591 Jul 16 08:07 input_mozilla_com.2010.07.16.sql.gz
-rwx------  1 root root 8719578 Jul 17 08:06 input_mozilla_com.2010.07.17.sql.gz
-rwx------  1 root root 8985084 Jul 18 08:09 input_mozilla_com.2010.07.18.sql.gz
-rwx------  1 root root 9244240 Jul 19 08:10 input_mozilla_com.2010.07.19.sql.gz

?

Comment 10

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

Ah, okay this works - I thought these would go into the mysql db on cm-webdev01-master01 - but this works for me.

-d

Comment 11

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

Also - I see the files, just no permissions on them.

chmod a+r please?

Comment 12

[timellis]

gave u sudo w00t.