jbonney/drop_tables.sh

Created September 17, 2014 06:03

Star (0) You must be signed in to star a gist
Fork (1) 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/jbonney/32a25f7ba0a266d3b3db.js"></script>
Save jbonney/32a25f7ba0a266d3b3db to your computer and use it in GitHub Desktop.

Download ZIP

Revisions

jbonney created this gist Sep 17, 2014.

drop_tables.sh

-Original file line number
+Diff line change
@@ -0,0 +1,5 @@
+    user=...
+    pass=...
+    host=localhost # or remote if necessary
+    database=...
+    mysqldump -u${user} -p${pass} -h ${host} --add-drop-table --no-data ${database} | grep ^DROP | mysql -u${user} -p${pass} -h ${host} ${database}