Linux Delete/Drop all MySQL tables from the command-line in one command

mysql_drop_all_tables.sh

#!/bin/bash

# /!\ keep space character at begening of command to avoid saving it in history

# real mysql DROP TABLE in one command -- very fast
 mysqldump --add-drop-table --no-data -u[USERNAME] -p[PASSWORD] [DATABASE]| grep -e '^DROP \| FOREIGN_KEY_CHECKS'| mysql -u[USERNAME] -p[PASSWORD] [DATABASE]

# OR

# loop x time on DROP TABLE, but no mysqldump -- https://stackoverflow.com/a/38814457/293214
 echo "[DATABASE]"| xargs -I{} sh -c "mysql -u[USERNAME] -p[PASSWORD] -Nse 'SHOW TABLES' {}| xargs -I[] mysql -u[USERNAME] -p[PASSWORD] -e 'SET FOREIGN_KEY_CHECKS=0; DROP TABLE []' {}"


# Examples:
 mysqldump --add-drop-table --no-data -uroot -proot magento| grep -e '^DROP \| FOREIGN_KEY_CHECKS'| mysql -uroot -proot magento
 mysqldump --add-drop-table --no-data -uroot -proot wordpress| grep -e '^DROP \| FOREIGN_KEY_CHECKS'| mysql -uroot -proot wordpress
 mysqldump --add-drop-table --no-data -uroot -proot drupal| grep -e '^DROP \| FOREIGN_KEY_CHECKS'| mysql -uroot -proot drupal
 mysqldump --add-drop-table --no-data -uroot -proot spip| grep -e '^DROP \| FOREIGN_KEY_CHECKS'| mysql -uroot -proot spip
 mysqldump --add-drop-table --no-data -uroot -proot shopware| grep -e '^DROP \| FOREIGN_KEY_CHECKS'| mysql -uroot -proot shopware
 mysqldump --add-drop-table --no-data -uroot -proot orocommerce| grep -e '^DROP \| FOREIGN_KEY_CHECKS'| mysql -uroot -proot orocommerce
 mysqldump --add-drop-table --no-data -uroot -proot symfony| grep -e '^DROP \| FOREIGN_KEY_CHECKS'| mysql -uroot -proot symfony