search

amutake / satsukita-andon.com

satsukita-andon.com
http://satsukita-andon.com
1 stars 1 forks source link

Intro #59

Closed amutake closed 10 years ago

amutake commented 10 years ago
  1. cd db && backup.sh

  2. edit backup.sql

    ...
INTRO VARCHAR DEFAULT '' NOT NULL
...
  3. restore.sh backup

  4. edit backup.sql

    ...
INTRO VARCHAR NOT NULL
...
  5. restore.sh backup
amutake commented 10 years ago 
% ./andon backup
% cp backup/2014-08-06.sql db/backup.sql
% ./andon stop
% cd db
% e backup.sql
  ...
  TOP VARCHAR,
  INTRO VARCHAR DEFAULT '' NOT NULL
  )
  ...
% rm default.h2.db
% ./restore.sh backup
% rm backup.sql
% ./backup.sh
% e backup.sql
  ...
  INTRO VARCHAR NOT NULL
  ...
% rm default.h2.db
% ./restore.sh backup
% rm backup.sql
% cd ../
% git pull origin master
% ./andon start