Difference between revisions of "User:Aeric/Backup Notes"

From LongJump Support Wiki
imported>Aeric
imported>Aeric
Line 21: Line 21:
# Login to server as root (PuTTY)
# Login to server as root (PuTTY)
# cd /usr/share/mediawiki
# cd /usr/share/mediawiki
# zip -rT lj{v}2.zip lj{v} # Create zip file
# zip -rT lj{ver}.zip lj{ver}   # Create zip file
# zip -l lj{v}2.zip         # Confirm contents
# zip -l lj{ver}.zip           # Confirm contents
# Use FileZilla to download
# Use FileZilla to download
# unzip locally
# unzip locally

Revision as of 20:00, 6 February 2012

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 -rT lj{ver}.zip lj{ver} # Create zip file
  5. zip -l lj{ver}.zip # Confirm contents
  6. Use FileZilla to download
  7. unzip locally