Page MenuHomePhabricator

Generate SQL dump for Wiki
Closed, ResolvedPublicRequest

Description

We've had a request to generate an SQL dump for a specific Wiki.

We need to provide the complete SQL dump for a specific wiki (id number === 167). This should be placed somewhere accessible over the internet but not publicly available. This is probably easiest to do using a google cloud bucket.

It should probably be encrypted.

Once this is done the details should be passed to Valerie so she can pass it on to the user.

Some notes containing internal information about this request (like where it is going) are in this WMDE internal google doc: https://docs.google.com/document/d/1Zx9e7SV5zba47PwBnkJWGKbGHmFmPC98900epUeyLSo/edit

Details

Due Date
Feb 22 2024, 12:00 AM

Event Timeline

Tarrow changed the task status from Open to Stalled.Jan 31 2024, 9:22 AM
Tarrow set Due Date to Feb 22 2024, 12:00 AM.Feb 1 2024, 1:28 PM
Charlie_WMDE changed the task status from Stalled to Open.Feb 1 2024, 2:07 PM

@Valerie_Wollinger_WMDE I created the encrypted dump and made it available for download. Instructions are in the Google Doc

Fring removed Fring as the assignee of this task.Feb 8 2024, 12:02 PM
Fring moved this task from Doing to In Review on the Wikibase Cloud (Kanban board Q1 2024) board.
Fring removed a subscriber: Valerie_Wollinger_WMDE.
Fring subscribed.

The procedure itself was pretty painless:

mysqldump --host="$DB_HOST" --port="$DB_PORT" --user="$DB_USER" --password="$DB_PASSWORD" $WIKIDB | gzip -c > ./$WIKIDB_dump.sql.gz

I encrypted the file locally after importing the user's key to my keychain

gpg --output $FILENAME.sql.gz.gpg --encrypt --recipient some.email@example.com $FILENAME.sql.gz
Tarrow changed the subtype of this task from "Task" to "Administrative Request".Feb 9 2024, 3:20 PM

File has been downloaded and can be deleted again.