User:Aeric/Backup Notes

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