Batch clear all tables in the mysql database _ MySQL

Batch clearing all tables in the mysql database sometimes we want to clear a database without deleting it. For example, if the local database is synchronized with the latest database file backed up by the server, the local database is cleared first.

Of course it cannot be useddrop databaseBecause it will be deleted together with the database. In fact, this is acceptable, but it is necessary to re-create an empty database with the same name. Or usedrop tableCommand to delete a table from a table? Er... In that case, it's not just the style of our geek programmers.

Here we will introduceHigh-endMethod, you have guessed it, that is, using shell script:

1. #!/bin/bash
2. MUSER="$1"
3. MPASS="$2"
4. MDB="$3"
6. # Detect paths
7. MYSQL=$(which mysql)
8. AWK=$(which awk)
9. GREP=$(which grep)
11. if[ $# -ne 3 ]
12. then
13. echo "Usage: $0 {MySQL-User-Name} {MySQL-User-Password} {MySQL-Database-Name}"
14. echo "Drops all tables from a MySQL"
15. exit1
16. fi
18. TABLES=$($MYSQL -u $MUSER -p$MPASS $MDB -e 'show tables'| $AWK '{ print $1}'| $GREP -v '^Tables')
20. for t in $TABLES
21. do
22. echo "Deleting $t table from $MDB database..."
23. $MYSQL -u $MUSER -p$MPASS $MDB -e "drop table $t"
24. done

This script is from the network. I have tried it myself and it is easy to use.

Usage

Save the preceding script as a sh file (For example, drop. table. sh), Execute./drop.table.sh USERNAME PWD DBNAME(Replace USERNAME, PWD, and DBNAME with your mysql User name, password, and database name..

Note:: In this way, your password is displayed in history and may be exploited by hackers.