[Summary view] [Print] [Text view]

   1  #!/bin/bash
   2  mysql -e "alter table corresp change os os CHAR(200) DEFAULT 'TOUS' NOT NULL;" se3db;
   3  mysql -e "alter table corresp change antidote antidote CHAR(200) DEFAULT 'TOUS' NOT NULL;" se3db;
   4  
   5  mysqldump se3db corresp >/tmp/corresp$$.sql
   6  sed -i 's/TypeXP/2000,XP,Vista,Seven/g' /tmp/corresp$$.sql
   7  sed -i 's/Type9x/Win9x/g' /tmp/corresp$$.sql
   8  mysql -e "delete from corresp;" se3db
   9  mysql se3db < /tmp/corresp$$.sql
  10  rm -f /tmp/corresp$$.sql