You could use the following command to drop all the tables of a MySQL DB.
- mysqldump -u<user> -p<pwd> --add-drop-table --no-data <db> | grep ^DROP | mysql -u<user> -p<pwd> <db>
Just replace the <user>, <pwd> and <db> with your MySQL username, password and database name. That’s all.
Done =)
Reference: MySQL drop all tables command
The MySQL commands such as mysqldump can be found in
- /Applications/MAMP/Library/bin/
Continue reading MAMP – Run MySQL commands in Terminal →
Export a database which is called Test:
mysqldump -u <username> -p Test > Test.sql
The sql file will be generated after you input the password. Continue reading MySQL – Import and Export Database with mysqldump →
Dream BIG and go for it =)