jbmurphy.com

Quick check if a mysql database exists

Here is my bash code that checks if a db exists before I try to create one in a script:

$DBNAME="dblookingfor"
DBEXISTS=$(mysql --batch --skip-column-names -e "SHOW DATABASES LIKE '"$DBNAME"';" | grep "$DBNAME" > /dev/null; echo "$?")
if [ $DBEXISTS -eq 0 ];then
	echo "A database with the name $DBNAME already exists. exiting"
	exit;
fi

This will exit out if there is a database with the name you are searching for. The tricky part for me (and always is) was this double quotes inside the single quotes in the LIKE statement.

Posted

in

,

by

jbmurphy

Tags:

,

Comments

6 responses to “Quick check if a mysql database exists”

  1. Daniele Avatar
    Daniele

    Great, thanks!

    You can even use “grep -q” instead o redirecting output to /dev/null.

  2. From a shell script, how can I check whether a MySQL database exists? – Just just easy answers

    […] http://www.jbmurphy.com/2011/02/08/quick-check-if-a-mysql-database-exists/ this is more akin to what I […]

  3. Fixed: From a shell script, how can I check whether a MySQL database exists? #programming #development #it | SevenNet

    […] http://www.jbmurphy.com/2011/02/08/quick-check-if-a-mysql-database-exists/ this is more akin to what I […]

  4. Fixed: From a shell script, how can I check whether a MySQL database exists? #solution #programming #development | Good Answer

    […] http://www.jbmurphy.com/2011/02/08/quick-check-if-a-mysql-database-exists/ this is more akin to what I […]

  5. Answer: From a shell script, how can I check whether a MySQL database exists? #solution #fix #it | IT Info

    […] http://www.jbmurphy.com/2011/02/08/quick-check-if-a-mysql-database-exists/ this is more akin to what I […]

  6. Dintr-un script shell, cum pot verifica dacă există o bază de date MySQL?

    […] la http://www.jbmurphy.com/2011/02/08/quick-check-if-a-mysql-database-exists/ acest lucru este mai apropiat de ceea ce am […]