Drop all mysql tables

To drop all mysql tables from the command line, use the following command:

mysqldump -u [username] -p [password] --add-drop-table --no-data [databasename] | grep ^DROP | mysql -u [username] -p [password] [databasename]

© GeekLabInfo Drop all mysql tables is a post from GeekLab.info. You are free to copy materials from GeekLab.info, but you are required to link back to http://www.geeklab.info

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...