Example scripts
Importing
All plain sql files at once
If your desired sql files that you want to import are prefixed with 2015-12-29_14-24__
you can use the following one-liner to import them all.
prefix="2015-12-29_14-24__"; \ for i in ${prefix}*.sql ; do \ db="$(echo "$i" | sed "s/${prefix}//" | sed 's/\.sql//')"; \ mysql -u root -e "CREATE DATABASE IF NOT EXISTS \`$db\`;"; \ mysql -u root $db < $i; \ done
All gzipped sql files at once
prefix="2015-12-29_14-24__"; \ for i in ${prefix}*.sql.gz ; do \ db="$(echo "$i" | sed "s/${prefix}//" | sed 's/\.sql\.gz//')"; \ mysql -u root -e "CREATE DATABASE IF NOT EXISTS \`$db\`;"; \ gunzip < "$i" | mysql -u root $db; \ done
All bzip2 sql files at once
prefix="2015-12-29_14-24__"; \ for i in ${prefix}*.sql.bz2 ; do \ db="$(echo "$i" | sed "s/${prefix}//" | sed 's/\.sql\.bz2//')"; \ mysql -u root -e "CREATE DATABASE IF NOT EXISTS \`$db\`;"; \ bunzip < "$i" | mysql -u root $db; \ done