drop database via bash with dash in database-name

Question

I have a variable in a script with the list of folder names with dash in their names

DBDIR="some directory"
dbdash=`ls -l $DBDIR | egrep '^d' | grep '.-.' | awk '{print $9}'`

And I want to drop every database with the same names with the folders in the variable "dbdash"

dbhype=($dbdash)
    for dbtry in ${!dbhype[*]}
        do            
            mysqladmin -u$dbUser -p$dbPass 'drop database if exists `'${dbhype[$dbtry]}'` CHARACTER SET utf8 COLLATE utf8_general_ci;'
    done

But this error came out after running the script

mysqladmin: Unknown command: 'drop database if exists folder_name CHARACTER SET utf8 COLLAT'

How can I delete these databases using script? Please help.

Don't parse ls, and don't try to store a list of files in a flat string. cd "$DBDIR"; dbhype=( *-*/ ) — chepner
– chepner, Commented Feb 24, 2016 at 13:48

chepner · Accepted Answer · 2016-02-24 13:50:06Z

1

Backquotes are for executing commands; you just want to quote the value (although the way you construct dbhype, quoting is too late to do you any good).

cd "DBDIR"
for dbtry in *-*/; do
    mysqladmin -u "$dbUser" -p "$dbPass" "drop database if exists '$dbtry'"
done

answered Feb 24, 2016 at 13:50

chepner

538k77 gold badges594 silver badges746 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

1312EN Over a year ago

thank you @chepner for this answer. i tried using this and edited a bit of it. I use this: mysql -u$dbUser -p$dbPass -e 'drop database if exists '$dbtry'' instead of: mysqladmin -u "$dbUser" -p "$dbPass" "drop database if exists '$dbtry'" and it worked!

Collectives™ on Stack Overflow

drop database via bash with dash in database-name

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related