#!/bin/bash typodb=idiv_website # staging # typodb=wwwidiv # live tables=('index_rel' 'index_fulltext' 'index_phash' 'tt_news') for table in ${tables[@]}; do mysql -e "truncate $typodb.$table" done