Skip to content

Instantly share code, notes, and snippets.

@LoganGray

LoganGray/mysql-drop-all-tables.sh

Forked from cweinberger/mysql-drop-all-tables.sh
Created July 24, 2018 21:32
Show Gist options
  • Save LoganGray/93e85c665c798edf2de800bf70365bd1 to your computer and use it in GitHub Desktop.
Save LoganGray/93e85c665c798edf2de800bf70365bd1 to your computer and use it in GitHub Desktop.
Download ZIP
drops all tables of a specific db
Raw
mysql-drop-all-tables.sh
#!/bin/bash
#usage: mysql-drop-all-tables -d database -u dbuser -p dbpass
TEMP_FILE_PATH='./drop_all_tables.sql'
while getopts d:u:p: option
do
case "${option}"
in
d) DBNAME=${OPTARG};;
u) DBUSER=${OPTARG};;
p) DBPASS=${OPTARG};;
esac
done
echo "SET FOREIGN_KEY_CHECKS = 0;" > $TEMP_FILE_PATH
( mysqldump --add-drop-table --no-data -u$DBUSER -p$DBPASS $DBNAME | grep 'DROP TABLE' ) >> $TEMP_FILE_PATH
echo "SET FOREIGN_KEY_CHECKS = 1;" >> $TEMP_FILE_PATH
mysql -u$DBUSER -p$DBPASS $DBNAME < $TEMP_FILE_PATH
rm -f $TEMP_FILE_PATH
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment