lib/pave/database.rb in pave-0.4.0 vs lib/pave/database.rb in pave-0.5.0

@@ -18,11 +18,19 @@
     def setup
       sh "mysql -uroot -e 'CREATE DATABASE #{name}'"
     end
 
     def dump
-      say "Creating dump of #{name} at #{Dir.pwd}/#{Time.now.strftime("%Y-%m-%d")}-#{name}.sql.gz"
-      sh "mysqldump -uroot #{name} | gzip > #{Time.now.strftime("%Y-%m-%d")}-#{name}.sql.gz"
+      if !File.directory?('db')
+        sh "mkdir ./db"
+        sh "echo '<?= die(); ?>' > ./db/index.php"
+        sh "echo 'deny from all' > ./db/.htaccess"
+        sh "sudo chmod -R 700 ./db/"
+      end
+      dbname = Time.now.strftime("%Y-%m-%d-%H%M") + "-" + name + ".sql.gz"
+      say "Creating dump of #{name} at #{Dir.pwd}/db/#{dbname}"
+      sh "mysqldump -uroot #{name} | gzip > ./db/#{dbname}"
+      say "Dump complete."
     end
 
     def download(host, user, password)
       # Download the project's live database and replace local database.
       # sh "mysqldump -h#{host} -u#{user} -p#{password} #{name} | mysql -uroot #{name}"