function resetdb()
{
    host="asdf"
    user="asdf"
    passwd="asdf"
    database=( "asdf" "sdf" )

    for db in ${database[@]}; do
        mysqlshow -u$user -p$passwd -h$host $db | sed -e "/\+/d" -e "s/[\ |\|]//g" -e "/^Tables*/d" -e "/^Database:*/d" | awk '{ print "DROP TABLE "  $0  ";" ; }' |  mysql -v -u$user -p$passwd -h$host $db
        mysql -u$user -p$passwd -h$host $db < ../../../database/$db.sql
        mysql -u$user -p$passwd -h$host $db < ../../../database/demo.sql
    done
}