oodavid · March 26, 2012 21:21 · Mar 26, 2012 · Mar 26, 2012 · Mar 26, 2012 · Mar 26, 2012
diff --git a/README.md b/README.md
@@ -21,7 +21,7 @@ This is a hands-on way to pull down a set of MySQL dumps from Amazon S3 and rest
     # Download all the snapshots
     s3cmd ls "$bucket"/"$s3folder"/ | grep -o "s3://.*\.sql\.gz" | xargs -n 1 -P 10 -I {} s3cmd get {} .
     # Unzip all the files
-    ls | grep "sql.gz" | xargs gunzip
+     ls | grep "sql.gz" | xargs -n 1 -P 10 -I {} gunzip {} .
     # Run each file through mysql
     find . -name '*.sql' | awk '{ print "source",$0 }' | mysql -u root -p$mysqlpass --batch
 

diff --git a/README.md b/README.md
@@ -19,7 +19,7 @@ This is a hands-on way to pull down a set of MySQL dumps from Amazon S3 and rest
     # Create a temporary directory and change to it
     cd $(mktemp -d)
     # Download all the snapshots
-    s3cmd ls $bucket/$s3folder/ | awk '{print $4}' | xargs -n 1 -P 10 -I {} s3cmd get {} .
+    s3cmd ls "$bucket"/"$s3folder"/ | grep -o "s3://.*\.sql\.gz" | xargs -n 1 -P 10 -I {} s3cmd get {} .
     # Unzip all the files
     ls | grep "sql.gz" | xargs gunzip
     # Run each file through mysql

diff --git a/README.md b/README.md
@@ -14,8 +14,8 @@ This is a hands-on way to pull down a set of MySQL dumps from Amazon S3 and rest
 
 ## 2 - Download all the snapshots in the S3 folder, extract them, run them through mysql
 
-    # Set the name of the directory you want to use (say "2012-03-26")
-    export s3folder="YYYY-MM-DD"
+    # Set the name of the directory you want to use (ie "1332796733 - Monday 26 March 2012 @ 2218")
+    export s3folder="1234567890 - DAY DD MONTH YYYY @ HHMM"
     # Create a temporary directory and change to it
     cd $(mktemp -d)
     # Download all the snapshots

diff --git a/README.md b/README.md
@@ -0,0 +1,31 @@
+# Restore MySQL from Amazon S3
+
+This is a hands-on way to pull down a set of MySQL dumps from Amazon S3 and restore your database with it
+
+***Sister Document - [Backup MySQL to Amazon S3](https://gist.github.com/2206527) - read that first***
+
+## 1 - Set your MySQL password and S3 bucket, make a temp dir, get a list of snapshots
+
+    # Set our variables
+    export mysqlpass="ROOTPASSWORD"
+    export bucket="s3://bucketname"
+    # Get a list of the snapshot dates, newest at the bottom
+    s3cmd ls $bucket | sort
+
+## 2 - Download all the snapshots in the S3 folder, extract them, run them through mysql
+
+    # Set the name of the directory you want to use (say "2012-03-26")
+    export s3folder="YYYY-MM-DD"
+    # Create a temporary directory and change to it
+    cd $(mktemp -d)
+    # Download all the snapshots
+    s3cmd ls $bucket/$s3folder/ | awk '{print $4}' | xargs -n 1 -P 10 -I {} s3cmd get {} .
+    # Unzip all the files
+    ls | grep "sql.gz" | xargs gunzip
+    # Run each file through mysql
+    find . -name '*.sql' | awk '{ print "source",$0 }' | mysql -u root -p$mysqlpass --batch
+
+## 3 - Check it all went smoothly
+
+    # Login to MySQL and have a poke
+    mysql -u root -p$mysqlpass
No results found