User:Jka: Difference between revisions

User:Jka (view source)

51 bytes removed , 16 February 2008

m

1,134

edits

@@ Line 42: / Line 42: @@
 === Backup ===
 *http://www.mediawiki.org/wiki/Manual:Moving_a_wiki
-*take snapshots of mysql dump and mediawiki settings
+*take snapshots of mysql dump and mediawiki settings  (using cygwin)
-**xcopy http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/xcopy.mspx?mfr=true
+**tablesfile=vdfwiki-$(date +%Y%m%d).sql
-**zip,unzip http://www.info-zip.org/
+**mysqldump -u root -p > $(tablesfile)
-*do a automated batch script that uploads the snapshots
+**mysqldump -u wikiuser -p wikidb > $(tablesfile)
-**http://www.speedguide.net/read_articles.php?id=1547
+**snapshot=vdfwiki-$(date +%Y%m%d).tbz
+**tar cjf $(snapshot)
+*do a automated batch script that uploads the snapshots (cron)
 **ncftpput: http://www.ncftp.com/ncftp/doc/ncftpput.html
-**schedule the batch : http://www.iopus.com/guides/winscheduler.htm
 ===Using MediaWiki extensions ===