vim tables_backup #!/bin/bash table_backup=`mysql -uroot -s -e " use mysql; show tables;"` for i in $table_backup do echo $i > /root/shell/tables/$i.sql done ~