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

From LongJump Support Wiki
imported>Aeric
imported>Aeric
 
(One intermediate revision by the same user not shown)
Line 20: Line 20:
# Start VPN.
# Start VPN.
# Login to server as root (PuTTY)
# Login to server as root (PuTTY)
# cd /usr/share/mediawiki
# <tt>cd /usr/share/mediawiki</tt>
# zip -rT lj{v}2.zip lj{v} # Create zip file
# <tt>zip -rvT {wiki}.zip {wiki}/</tt>  # Create zip file
# zip -l lj{v}2.zip         # Confirm contents
# <tt>zip -l {wiki}.zip</tt>            # Confirm contents
# Use FileZilla to download
# Use FileZilla to download
# unzip locally
# unzip locally

Latest revision as of 22:59, 27 September 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 -rvT {wiki}.zip {wiki}/ # Create zip file
  5. zip -l {wiki}.zip # Confirm contents
  6. Use FileZilla to download
  7. unzip locally