#!/bin/bash TABLES="tbl_cohorten lesperioden wegingen POitems STitems" for i in $TABLES; do mdb-schema -T $i $1 mysql | grep -v -e "^COMMENT ON TABLE" | grep -v -e "^COMMENT ON COLUMN" done for i in $TABLES; do mdb-export -I mysql $1 $i done