X-Git-Url: http://matita.cs.unibo.it/gitweb/?p=helm.git;a=blobdiff_plain;f=matita%2Fscripts%2Fclean_db.sh;fp=matita%2Fscripts%2Fclean_db.sh;h=0d0767573d30c61c63313a3c6093fa58e03debec;hp=0000000000000000000000000000000000000000;hb=f61af501fb4608cc4fb062a0864c774e677f0d76;hpb=58ae1809c352e71e7b5530dc41e2bfc834e1aef1 diff --git a/matita/scripts/clean_db.sh b/matita/scripts/clean_db.sh new file mode 100755 index 000000000..0d0767573 --- /dev/null +++ b/matita/scripts/clean_db.sh @@ -0,0 +1,7 @@ +#!/bin/sh + +TBL=`echo show tables | mysql matita -u helm | grep -v _` +for X in $TBL; do + echo cleaning $X + echo "delete from $X where source like 'cic:/matita/%'" | mysql matita -u helm +done