Apr 062012
 

LG9UXL: (Version 0.2) :[locked: AnytimeInnovator is editing this externally as wp_backup_LGE800.htm

  1. LGA8GF:Overall
    1. LGA8GL: Official page http://codex.wordpress.org/WordPress_Backups
  2. LG9XDZ:Backing up WordPress (database & files) via (not mutually-exclusive):
    1. LG9XFR: standard approach: a standard backup approach
    2. LG9X87: SCM approach: a SCM (such as git or Bazzar)
      1. LG9UYO: since I’ve know WordPress, this has seemed the best approach.
      2. LG9XAA:Pros thru cons:
        1. LG9XLN: huge pro: Infinite versions, all history
        2. LG9XM0: big pro: professional differencing & merging
        3. LG9XNK:Pro: what you’d have-to/better do if you were editing templates or other customizations besides plugins, and what all 3 of 3 developers I’ve spoken with ended up doing (all used git)
          1. LGA3DQ: Related is http://wordpress.org/extend/plugins/wordpressdeploy/
          2. LGAA8R:Related to this (for at least database development) is (impressive) http://Liquibase.Org
            1. LGAAB4: 1st ref;d by http://news.ycombinator.com/item?id=600268
            2. LGAA8L: GS[Liquibase database backup] finds little so it’s not really a backup tool it seems
        4. LG9XN7: Con: no popular support
      3. LGA3GQ:Which SCM to use?
        1. LGA3GX:svn
          1. LGA3HC: Pro: used to develop WordPress itself
          2. LGA3HR: Con: rapidly criticized by DVCS
          3. LGA3Y4: http://wordpress.org/extend/plugins/tags/svn has 10 matches, but none for this job
          4. LGA95M: MySql to svn http://news.ycombinator.com/item?id=600268 “I wrote a short Ruby script that does a similar operation with Subversion
        2. LGA3IL:git
          1. LGA3IV: http://wordpress.org/extend/plugins/search.php?q=git gives 19 hits though none for this job
          2. LGAAMA:GS[WordPress MySQL backup git] finds
            1. LGAAKP: Hacker News | Backup your Database in Git
            2. LGAATR: http://www.noupe.com/how-tos/10-ways-to-automatically-manually-backup-mysql-database.html/comment-page-1#comment-36251 gives real code, plus next comment
            3. LGAFGC: http://inchoo.net/tools/setup-for-automatic-magento-database-backup-in-git gives full code
            4. LGAFX3: http://blog.jerodsanto.net/2009/05/git-informed-when-your-site-is-hacked/
            5. LGAGFH: http://www.howtojoomla.net/how-tos/development/how-to-track-your-joomla-project-with-git
            6. LGAGFT: http://wordpress.stackexchange.com/questions/617/what-process-do-you-use-for-wordpress-development#history-621
        3. LGA4CV:bazaar
          1. LGA3U9: http://www.google.com/search?q=site:http://wordpress.org/extend/plugins/%20bazaar+OR+bzn gives 0 results.
        4. LGA46Q:Mercurial
          1. LGA47J: http://google.com/search?q=site%3Ahttp%3A%2F%2Fwordpress.org%2Fextend%2Fplugins%2F+Mercurial+OR+Hg finds 9 results, but none of them for this and they’re all just plugins which are being developed in this SCM
    3. LG9XR4:A method which works for most PHP sites, not just WordPress
      1. LG9XS4:Some actual examples I’ve seen:
        1. LG9XYG: http://wordpress.org/extend/plugins/xcloner-backup-and-restore “custom backups of any LAMP website through custom admin inputs” “uses Open Source standards like TAR and Mysql formats”
    4. LG9YD1:Esp if rolling one’s own
      1. LG9YCA:Might want to look at/use existing systems as
        1. LG9Z64: Probably others, as among those with high ratings that have been downloaded a bit
        2. LGA282:http://wordpress.org/extend/plugins/wordpress-automatic-upgrade/
          1. LGA2AM: ref’d by http://wordpress.org/extend/plugins/browse/top-rated/page/4/
          2. LGA2CG: q[q[    * Version 1.2.5     * Updated 2009-2-19     * Downloads 408,246     * Average Rating      3.8 of 5]]
          3. ” upgrade the wordpress installation to the latest one provided by wordpress.org using the 5 steps provided in the wordpress upgrade instructions.”
        3. LGAELA:Raw scripts
          1. LGAELY: noupe.com’s: Several on http://noupe.com/how-tos/10-ways-to-automatically-manually-backup-mysql-database.html
          2. LGAEUB:http://www.lenzg.net/mylvmbackup/ – scalable, Packaged for Debian
            1. LGAF6O: Ref’d by noupe.com’s -> http://www.mysqlperformanceblog.com/2009/03/03/10-things-you-need-to-know-about-backup-solutions-for-mysql/comment-page-1/#comment-495505
          3. LGACAD: Raw script as noupe.com’s comment-76728
          4. LGAEKP: Raw script as AutoMySQLBackup
            1. LGAENK: Ref’d by noupe.com’s & noupe’s comment-412882 ->  http://blog.0x1fff.com/2011/01/quick-dump-or-backup-all-databases-in.html?showComment=1294576443333#c2699940527985454834
          5. LGAFN9: http://www.commandlinefu.com/commands/view/3077/create-encrypted-wordpress-mysql-backup-without-any-db-details-just-the-wp-config.php – parses settings out of wp-config
        4. LGA20G:http://wordpress.org/extend/plugins/wp-dbmanager/
          1. LGA221: Ref’d by http://wordpress.org/extend/plugins/browse/top-rated/page/4/
          2. LGA229: q[    * Version 2.60     * Updated 2010-10-5     * Downloads 326,948     * Average Rating       4.5 of 5]
        5. LGA0M5: WP-DB-Backup: http://austinmatzko.com/wordpress-plugins/wp-db-backup/
          1. LGA0HN: Don’t know why http://wordpress.org/extend/plugins/search.php?q=filosofo+backup&sort= this won’t find it, but should.
          2. LGA0HY: Top rated backup plugin, says http://wordpress.org/extend/plugins/browse/top-rated/
          3. LGA0LC: q[    * Version 2.2.3     * Updated 2010-12-21     * Downloads 823,765     * 4.0 of 5]
        6. LGA0FD: http://wordpress.org/extend/plugins/wp-db-backup/ aka (but not linked)
        7. LG9YYW:http://wordpress.org/extend/plugins/bei-fen/
          1. LG9Z4M: q[    * Version 1.4.2     * Updated 2009-12-31     * Downloads 11,790     * Average Rating      4of 5 stars]
        8. LG9YCT:http://wordpress.org/extend/plugins/remote-database-backup/faq/
          1. LG9YUG: Mentions it’s a variant of  WP-DB-Backup
          2. LG9Z3V: q[    * Version 1.00.1     * Updated 2009-7-10     * Downloads 15,715     * Average Rating       3.9of5]
  3. LG9ZCX:http://wordpress.org/extend/plugins/tags/backup
    1. LG9ZDE: lists ~36
  4. LG9UTQ:starting about 1 week ago, read http://wordpress.org/extend/plugins/search.php?q=backup
    1. LG9XHL: Only saw standard approach not SCM approach
    2. LG9ZB4: Lists about 17 before getting unrelated.
  5. LGA39G: Searched down to http://wordpress.org/extend/plugins/browse/top-rated/page/9/
    LG9UWT:

p

LG9UTQ: starting about 1 week ago, read http://wordpress.org/extend/plugins/search.php?q=backup LG9UXL:d