search

ariana-paris / otwarchive-gcode-issues

Apache License 2.0
0 stars 0 forks source link

Backup: basic functionality #55

Closed ariana-paris closed 9 years ago

ariana-paris commented 9 years ago

Original issue 55 created by dasbero on 2008-05-06T07:30:25.000Z:

Create backup plugin. See:

http://wiki.transformativeworks.org/mediawiki/internal/index.php/Archive_of_Our_Own_Roadmap#Backup

ariana-paris commented 9 years ago

Comment #1 originally posted by @ariana-paris on 2008-06-04T00:23:05.000Z:

<empty>

ariana-paris commented 9 years ago

Comment #2 originally posted by @ariana-paris on 2008-06-06T02:20:24.000Z:

Just updating this issue to say I've put up some thoughts on backup requirements and options at

http://docs.google.com/Doc?id=dchqkzsx_3dmbgdnfg

How we back up the database depends partly on how we back up the server itself.

I have written a rake task that can dump the tables, but I haven't checked it in because I'm not sure where I want to go with it just yet. Do I want the rake task to create and maintain the incrementals, or do I just want it to dump the database, and then have the server backup create and maintain the incrementals, for example.

ariana-paris commented 9 years ago

Comment #3 originally posted by @ariana-paris on 2008-06-08T22:32:32.000Z:

first pass in r285

still to do - purge old files & identify fields instead of complete tables

to use, cp config/backup.example config/backup.yml edit backup.yml

mkdir db/backup chmod 770 db/backup chgrp mysql db/backup

add to crontab
0 0 * * * cd YOUR_RAILS_ROOT && rake db:backup

make sure you only mirror the backup directory and not do incremental backups on it, or the purging won't be effective

ariana-paris commented 9 years ago

Comment #4 originally posted by @ariana-paris on 2008-06-25T05:52:17.000Z:

<empty>

ariana-paris commented 9 years ago

Comment #5 originally posted by shalott on 2008-09-02T13:35:17.000Z:

This one I think we probably want to get in before beta, so marking higher priority.

ariana-paris commented 9 years ago

Comment #6 originally posted by @ariana-paris on 2008-09-03T01:04:01.000Z:

I've fixed it so it can run more than once a day and isn't so brittle. Added purge old versions on different schedules by table. It's not a plugin and you can't specify fields within a table, but I think it's sufficient.

ariana-paris commented 9 years ago

Comment #7 originally posted by Black0Samvara on 2008-09-04T10:40:38.000Z:

<empty>

ariana-paris commented 9 years ago

Comment #8 originally posted by Black0Samvara on 2008-09-07T05:21:51.000Z:

I have no idea how to test this - what would be considered a sufficient test and who would do it?

ariana-paris commented 9 years ago

Comment #9 originally posted by @ariana-paris on 2008-09-07T06:46:10.000Z:

restoring the database would be a sufficient test. Someone would have to run this script a few times on their system, after making changes, and then wipe their database and see if they can restore.

ariana-paris commented 9 years ago

Comment #10 originally posted by @ariana-paris on 2008-09-30T19:18:40.000Z:

Would you consider the fact that I restored the testarchive from the beta archive backup to be sufficient proof that this is FixedAndVerified?

ariana-paris commented 9 years ago

Comment #11 originally posted by shalott on 2008-09-30T19:41:20.000Z:

I would! \o/

ariana-paris commented 9 years ago

Comment #12 originally posted by @ariana-paris on 2009-02-25T01:43:19.000Z:

<empty>

ariana-paris commented 9 years ago

Comment #13 originally posted by Black0Samvara on 2009-02-25T03:22:49.000Z:

Updating status on discussion with Jennifew and Sidra

ariana-paris commented 9 years ago

Comment #14 originally posted by autumna on 2010-11-13T22:13:05.000Z:

listing all former issues for automated tests

ariana-paris commented 9 years ago

Comment #15 originally posted by autumna on 2010-11-14T19:39:51.000Z:

Converting from NeedsTest status to NeedsTest label