MySQL Empty Database / Delete or Drop All Tables
MySQL Empty Database / Delete or Drop All Tables MySQL drop all tables syntax: DROP DATABASE { mysql-database-name } Method #1: Empty database with root user In order to use this procedure you must have the drop and create database privilege (otherwise you will drop database but not able to create it again). Login as MySQL root or admin user to drop atomstore database: $ mysql -u root -p Now drop database: mysql> DROP DATABASE atomstore; Now create database again: mysql> CREATE DATABASE atomstore; Exit and close the session: mysql> quit Method #2: Drop all tables using shell script w/o root access I've small handy shell script that removes all tables without dropping and creating MySQL database again. #!/bin/bash MUSER= "$1" MPASS= "$2" MDB= "$3" # Detect paths MYSQL= $ ( which mysql ) AWK= $ ( which awk ) GREP= $ ( which grep ) if [ $# -ne 3 ] then echo "Usage: $...