Skip to content

Instantly share code, notes, and snippets.

@Somrlik

Somrlik/drop-all-tables.sh

Created March 15, 2020 16:46
Show Gist options
  • Save Somrlik/8751861c4e3cee2391e020cc976a7ef6 to your computer and use it in GitHub Desktop.
Save Somrlik/8751861c4e3cee2391e020cc976a7ef6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
drop-all-tables.sh
#!/usr/bin/env bash
MYSQL_DATABASE="db_name"
MYSQL_USER="root"
MYSQL_PASS="root"
MYSQL_HOST="127.0.0.1"
TMP_FILENAME="/tmp/tmp.sql"
echo "SET FOREIGN_KEY_CHECKS = 0;" > ${TMP_FILENAME}
mysqldump \
--add-drop-table \
--no-data \
--host ${MYSQL_HOST} \
-u ${MYSQL_USER} -p${MYSQL_PASS} \
${MYSQL_DATABASE} | grep 'DROP TABLE' >> ${TMP_FILENAME}
echo "SET FOREIGN_KEY_CHECKS = 1;" >> ${TMP_FILENAME}
cat ${TMP_FILENAME}
mysql --host ${MYSQL_HOST} \
-u ${MYSQL_USER} -p${MYSQL_PASS} \
${MYSQL_DATABASE} < ${TMP_FILENAME}
rm ${TMP_FILENAME}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment