Svel/droptables.sh

Created April 7, 2012 10:51

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Svel/2327455.js"></script>
Save Svel/2327455 to your computer and use it in GitHub Desktop.

Download ZIP

Drop all tables in DB when you r on shared hosting without GRANT

Raw

droptables.sh

mysqldump -u[USERNAME] -p[PASSWORD] -h[HOST] --add-drop-table --no-data [DATABASE] | grep ^DROP | mysql -u[USERNAME] -p[PASSWORD] -h[HOST] [DATABASE]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment