Mercurial > backup

     1 #!/bin/sh

     2 

     3 TARGET_DIR=`date +%Y.%m.%d-%H.%M`

     4 

     5 mkdir /home/r/proj/6.034/archive/$TARGET_DIR

     6 

     7 cd /home/r/proj/6.034/archive/$TARGET_DIR

     8 

     9 

    10 python2 /home/r/bin/gcp.py -f csv -p 68686960606- bortreb@gmail.com:/all/all/6.034* .

    11 python2 /home/r/bin/gcp.py -p 68686960606- bortreb@gmail.com:/all/all/6.034* .

    12 

    13 echo "Backup tester DB"

    14 

    15 mysqldump -h sql.mit.edu -ptU45~br8nz -u \

    16     6.034 6034+fall12_tester > ./6.034-tester.sql

    17 

    18 echo "Backup wiki DB"

    19 

    20 mysqldump -h sql.mit.edu -ptU45~br8nz -u \

    21     6.034 6034+fall12_wiki > ./6.034-wiki.sql

    22 

    23 echo "Backup all-databases"

    24 

    25 mysqldump -h sql.mit.edu -ptU45~br8nz -u \

    26     6.034 --all-databases > ./6.034-all-databases.sql

    27 

    28 du -shc ./*

    29
author	Robert McIntyre <rlm@mit.edu>
date	Thu, 29 Jan 2015 20:51:17 -0800
parents	d3b029607539
children