User:Aeric/Backup Notes

From LongJump Support Wiki
< User:Aeric
Revision as of 22:59, 27 September 2012 by imported>Aeric
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Database Export
Easiest way is to use phpMyAdmin
-or-
mysqldump -u[USERNAME] -p[DBNAME] | bzip2 > [/path_to_file/DBNAME]_data.sql.bz2
Database Import
cd /path_to_file
bunzip2 [DBNAME].sql.bz2
mysql -uName -pPW wikiNN < [DBNAME]_data.sql
Files
  1. Start VPN.
  2. Login to server as root (PuTTY)
  3. cd /usr/share/mediawiki
  4. zip -rvT {wiki}.zip {wiki}/ # Create zip file
  5. zip -l {wiki}.zip # Confirm contents
  6. Use FileZilla to download
  7. unzip locally