Austrian Economics Wiki:Backups: Difference between revisions
No edit summary |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
In order to prevent catastrophic loss of data, maintaining offsite backups of Mises Wiki is a sound idea. As of 2009, the server used {{w|Standard_RAID_levels#RAID_1|RAID 1}}, which mirrors all content on another hard drive; while this provides a backup in case one hard drive {{w|Hard disk drive failure|fails}}, it does not protect against accidental and malicious deletions. As of 2009, a backup of the Mises database with confidential data stripped out was available here, at least to those whose IP addresses had been added to the whitelist:<ref>{{cite web|title=Database information|url=http://mises.org/community/wikis/ideas/database-information/revision/5.aspx|author=Veksler, David|date=31 October 2009}}</ref> Backups are also made at least as often as MediaWiki is [[mw:Manual:Upgrading|upgraded]]. | In order to prevent catastrophic loss of data, maintaining offsite backups of Mises Wiki is a sound idea. As of 2009, the server used {{w|Standard_RAID_levels#RAID_1|RAID 1}}, which mirrors all content on another hard drive; while this provides a backup in case one hard drive {{w|Hard disk drive failure|fails}}, it does not protect against accidental and malicious deletions. As of 2009, a backup of the Mises database with confidential data stripped out was available here, at least to those whose IP addresses had been added to the whitelist:<ref>{{cite web|title=Database information|url=http://mises.org/community/wikis/ideas/database-information/revision/5.aspx|author=Veksler, David|date=31 October 2009}}</ref> Backups are also made at least as often as MediaWiki is [[mw:Manual:Upgrading|upgraded]]. The database backups are kept as sql files in <code>/home/web/wiki_backup</code> . | ||
*data.mises.org | *data.mises.org | ||
| Line 6: | Line 6: | ||
The command that developers use to create a backup is: | The command that developers use to create a backup is: | ||
mysqldump -u [db username] --password=[db password] [db name] > wiki_backup.sql | mysqldump -u [db username] --password=[db password] [db name] > /home/web/wiki_backup/mises_wiki_backup_yyyymmdd.sql | ||
==References== | ==References== | ||
Latest revision as of 03:58, 5 October 2013
In order to prevent catastrophic loss of data, maintaining offsite backups of Mises Wiki is a sound idea. As of 2009, the server used RAID 1, which mirrors all content on another hard drive; while this provides a backup in case one hard drive fails, it does not protect against accidental and malicious deletions. As of 2009, a backup of the Mises database with confidential data stripped out was available here, at least to those whose IP addresses had been added to the whitelist:[1] Backups are also made at least as often as MediaWiki is upgraded. The database backups are kept as sql files in /home/web/wiki_backup .
- data.mises.org
- Username: miseshelp
- Password: miseshelp1
The command that developers use to create a backup is:
mysqldump -u [db username] --password=[db password] [db name] > /home/web/wiki_backup/mises_wiki_backup_yyyymmdd.sql
References
- ↑ Veksler, David (31 October 2009). "Database information". http://mises.org/community/wikis/ideas/database-information/revision/5.aspx.