Difference between revisions of "User:Aeric/Backup Notes"
From LongJump Support Wiki
imported>Aeric |
imported>Aeric |
||
| Line 1: | Line 1: | ||
;Export: | ;Database Export: | ||
:Easiest way is to use phpMyAdmin | :Easiest way is to use phpMyAdmin | ||
:-or- | :-or- | ||
| Line 8: | Line 8: | ||
|} | |} | ||
;Import: | ;Database Import: | ||
:{| | :{| | ||
<pre> | <pre> | ||
| Line 16: | Line 16: | ||
</pre> | </pre> | ||
|} | |} | ||
;Files: | |||
# Start VPN. | |||
# Login to server as root (PuTTY) | |||
# cd /usr/share/mediawiki | |||
# zip -rT lj{v}2.zip lj{v} # Create zip file | |||
# zip -l lj{v}2.zip # Confirm contents | |||
# Use FileZilla to download | |||
# unzip locally | |||
Revision as of 19:58, 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
- Start VPN.
- Login to server as root (PuTTY)
- cd /usr/share/mediawiki
- zip -rT lj{v}2.zip lj{v} # Create zip file
- zip -l lj{v}2.zip # Confirm contents
- Use FileZilla to download
- unzip locally