Project

General

Profile

« Previous | Next » 

Revision 6941

Added by Aaron Marcuse-Kubitza almost 12 years ago

README.TXT: Name archived imports without the "public." prefix so that their backups will work with the new `make backups/%.backup/remove` command, which does not add back the prefix

View differences:

README.TXT
55 55 
    Otherwise, continue
56 56 
    Determine the import name:
57 57 
        bin/import_name inputs/{.,}*/*/logs/*.r<revision>[.-]*log.sql
58 
    Archive the last import: make schemas/rename/public.<import_name>
58 
    Archive the last import: make schemas/rename/<import_name>
59 59 
    Delete previous imports so they won't bloat the full DB backup:
60 60 
        make backups/vegbien.<version>.backup/remove
61 61 
    make backups/TNRS.backup-remake &
62 62 
    make backups/vegbien.<version>.backup/test &
63 
    env public=public.<version> bin/export_analytical_db &
63 
    env public=<version> bin/export_analytical_db &
64 64 
    sudo backups/fix_perms
65 65 
    make backups/upload
66 66 
    On jupiter:
......
71 71 
    On nimoy:
72 72 
        cd /home/bien/svn/
73 73 
        svn up
74 
        make backups/analytical_aggregate.public.<version>.csv/download
75 
        make backups/analytical_aggregate.public.<version>.csv.md5/test
74 
        make backups/analytical_aggregate.<version>.csv/download
75 
        make backups/analytical_aggregate.<version>.csv.md5/test
76 76 
        Check that "OK" is printed next to the filename
77 77 
        In the bien_web DB:
78 78 
            Create the analytical_aggregate_r<revision> table using its schema
79 79 
                in schemas/vegbien.my.sql
80 80 
        env table=analytical_aggregate_r<revision> bin/publish_analytical_db \
81 
            backups/analytical_aggregate.public.<version>.csv
81 
            backups/analytical_aggregate.<version>.csv
82 82 
    If desired, record the import times in inputs/import.stats.xls:
83 83 
        Open inputs/import.stats.xls
84 84 
        Insert a copy of the leftmost Column-based column group before it
......
96 96 

  		




  97
  97
  
    
Backups:


  		




  98
  98
  
    
    Archived imports:


  		




  99
  
  
    
        Back up: make backups/public.<date>.backup &


  		




  
  99
  
    
        Back up: make backups/<date>.backup &


  		




  100
  100
  
    
            Note: To back up the last import, you must archive it first:


  		




  101
  101
  
    
                make schemas/rotate


  		




  102
  
  
    
        Test: make backups/public.<date>.backup/test &


  		




  103
  
  
    
        Restore: make backups/public.<date>.backup/restore &


  		




  104
  
  
    
        Remove: make backups/public.<date>.backup/remove


  		




  
  102
  
    
        Test: make backups/<date>.backup/test &


  		




  
  103
  
    
        Restore: make backups/<date>.backup/restore &


  		




  
  104
  
    
        Remove: make backups/<date>.backup/remove


  		




  105
  105
  
    
        Download: make backups/download


  		




  106
  106
  
    
    TNRS cache:


  		




  107
  107
  
    
        Back up: make backups/TNRS.backup-remake &


  		












Also available in:  Unified diff