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

Latest revision as of 22:59, 27 September 2012

mysqldump -u[USERNAME] -p[DBNAME] | bzip2 > [/path_to_file/DBNAME]_data.sql.bz2

cd /path_to_file
bunzip2 [DBNAME].sql.bz2
mysql -uName -pPW wikiNN < [DBNAME]_data.sql

@@ Line 1: / Line 1: @@
-;Import:<tt>mysql -uName -pPW wikiNN < wikiNN_data.sql</tt>
+;Database Export:
+:Easiest way is to use phpMyAdmin
+:-or-
+:{|
+<pre>
+mysqldump -u[USERNAME] -p[DBNAME] | bzip2 > [/path_to_file/DBNAME]_data.sql.bz2
+</pre>
+|}
+;Database Import:
+:{|
+<pre>
+cd /path_to_file
+bunzip2 [DBNAME].sql.bz2
+mysql -uName -pPW wikiNN < [DBNAME]_data.sql
+</pre>
+|}
+;Files:
+# Start VPN.
+# Login to server as root (PuTTY)
+# <tt>cd /usr/share/mediawiki</tt>
+# <tt>zip -rvT {wiki}.zip {wiki}/</tt>   # Create zip file
+# <tt>zip -l {wiki}.zip</tt>             # Confirm contents
+# Use FileZilla to download
+# unzip locally