https://wiki.frontyardprojects.org/index.php?action=history&feed=atom&title=Backing_up_this_WikiBacking up this Wiki - Revision history2026-05-27T23:15:00ZRevision history for this page on the wikiMediaWiki 1.30.0https://wiki.frontyardprojects.org/index.php?title=Backing_up_this_Wiki&diff=564&oldid=prevEquivalentideas at 07:06, 26 March 20232023-03-26T07:06:53Z<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr style="vertical-align: top;" lang="en-GB">
<td colspan="2" style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: white; color:black; text-align: center;">Revision as of 07:06, 26 March 2023</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">== Backing up this Wiki ==</del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>This is the research completed at the digital gardening bee 30th June 2018—it is yet to be implemented:<blockquote>1. Use mysqldump to make a backup</blockquote><blockquote>https://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki#Mysqldump_from_the_command_line</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>This is the research completed at the digital gardening bee 30th June 2018—it is yet to be implemented:<blockquote>1. Use mysqldump to make a backup</blockquote><blockquote>https://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki#Mysqldump_from_the_command_line</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>2. You’ll want to save to a different filename every time, e.g.</blockquote><blockquote>nice -n 19 mysqldump -u $USER --password=$PASSWORD $DATABASE -c | nice -n 19 gzip -9 > ~/backup/wiki-$DATABASE-$(date '+%Y%m%d').sql.gz</blockquote><blockquote>You can skip the “nice -n 19” parts of this command, but the useful part is the date.</blockquote><blockquote>3. Test that the backup works</blockquote><blockquote>https://www.mediawiki.org/wiki/Manual:Restoring_a_wiki_from_backup</blockquote><blockquote>I’m not super clear on how to test.</blockquote><blockquote>4. Passwords are hashed and salted, so it’s probably ok. Use scp/sftp to copy, e.g.</blockquote><blockquote>scp wikifile.gz remote.server:~/backups/</blockquote><blockquote>5. You can put all that in a batch script and then use crontab. See</blockquote><blockquote>https://www.mediawiki.org/wiki/User:Flominator/Backup_MW</blockquote></div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>2. You’ll want to save to a different filename every time, e.g.</blockquote><blockquote>nice -n 19 mysqldump -u $USER --password=$PASSWORD $DATABASE -c | nice -n 19 gzip -9 > ~/backup/wiki-$DATABASE-$(date '+%Y%m%d').sql.gz</blockquote><blockquote>You can skip the “nice -n 19” parts of this command, but the useful part is the date.</blockquote><blockquote>3. Test that the backup works</blockquote><blockquote>https://www.mediawiki.org/wiki/Manual:Restoring_a_wiki_from_backup</blockquote><blockquote>I’m not super clear on how to test.</blockquote><blockquote>4. Passwords are hashed and salted, so it’s probably ok. Use scp/sftp to copy, e.g.</blockquote><blockquote>scp wikifile.gz remote.server:~/backups/</blockquote><blockquote>5. You can put all that in a batch script and then use crontab. See</blockquote><blockquote>https://www.mediawiki.org/wiki/User:Flominator/Backup_MW</blockquote></div></td></tr>
</table>Equivalentideashttps://wiki.frontyardprojects.org/index.php?title=Backing_up_this_Wiki&diff=563&oldid=prevEquivalentideas: Created page with "== Backing up this Wiki == This is the research completed at the digital gardening bee 30th June 2018—it is yet to be implemented:<blockquote>1. Use mysqldump to make a bac..."2023-03-26T07:06:41Z<p>Created page with "== Backing up this Wiki == This is the research completed at the digital gardening bee 30th June 2018—it is yet to be implemented:<blockquote>1. Use mysqldump to make a bac..."</p>
<p><b>New page</b></p><div>== Backing up this Wiki ==<br />
<br />
This is the research completed at the digital gardening bee 30th June 2018—it is yet to be implemented:<blockquote>1. Use mysqldump to make a backup</blockquote><blockquote>https://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki#Mysqldump_from_the_command_line<br />
2. You’ll want to save to a different filename every time, e.g.</blockquote><blockquote>nice -n 19 mysqldump -u $USER --password=$PASSWORD $DATABASE -c | nice -n 19 gzip -9 > ~/backup/wiki-$DATABASE-$(date '+%Y%m%d').sql.gz</blockquote><blockquote>You can skip the “nice -n 19” parts of this command, but the useful part is the date.</blockquote><blockquote>3. Test that the backup works</blockquote><blockquote>https://www.mediawiki.org/wiki/Manual:Restoring_a_wiki_from_backup</blockquote><blockquote>I’m not super clear on how to test.</blockquote><blockquote>4. Passwords are hashed and salted, so it’s probably ok. Use scp/sftp to copy, e.g.</blockquote><blockquote>scp wikifile.gz remote.server:~/backups/</blockquote><blockquote>5. You can put all that in a batch script and then use crontab. See</blockquote><blockquote>https://www.mediawiki.org/wiki/User:Flominator/Backup_MW</blockquote></div>Equivalentideas