Changes between Version 13 and Version 14 of MySql

Timestamp:

06/20/11 16:15:15 (7 years ago)

Author:

joshuadf

Comment:

--

MySql

@@ -18 +18 @@
 }}}
 
+== Basic dump and restore ==
+
+{{{
+MYDB=my_database_name
+mysqldump $MYDB > mydb.dump
+# destroy the database contents without dropping it to retain permissions
+mysql $MYDB -BNe "show tables" | awk '{print "set foreign_key_checks=0; DROP TABLE `" $1 "`;"}' | mysql $MYDB
+mysql $MYDB < mydb.dump
+}}}
+
 == Editing a dump file ==
 
 Sometimes it is handy to edit a database by editing the text dump file.
 The `skip-extended-insert` dump format is easier to work with because 
-it puts one row on each line. Here is one way to do it:
+it puts one row on each line. However, note that it is also much slower to 
+load than the default dump format. Here is one way to do edit a dump:
 
 {{{
@@ -32 +43 @@
 nano new.dump
 # destroy the database contents
-mysqldump --add-drop-table --no-data $MYDB |grep DROP | mysql $MYDB
+mysql $MYDB -BNe "show tables" | awk '{print "set foreign_key_checks=0; DROP TABLE `" $1 "`;"}' | mysql $MYDB
 mysql $MYDB < new.dump 
 }}}