baldwindavid / dumpimp Goto Github PK

dumpimp
========

Rake tasks to dump and import various database batch files. (currently only MySQL, but feel free to add additional)

  db:dump
  =====================
  Description: Dump database file and gzip for RAILS_ENV.  Initial path of dump is to "db/".  Set alternate path with INITIAL_PATH=path/to/dump/.  To skip gzip use GZIP=no.
  
  Options:
    INITIAL_PATH=/my/db/dump/path/  (defaults to db/)
    GZIP=yes|no (defaults to yes)
    RAILS_ENV=production|development|test (default is development)

  Examples:
    rake db:dump
      - dumps development database to file in db/ folder
      - then gzips the file so you're left with "env_database_name_dump.sql.gz"
  
    rake db:dump INITIAL_PATH=.
      - same as above except dumps into root of your application instead of db/
  
    rake db:dump GZIP=no RAILS_ENV=production
      - dumps production database to sql file in db/ folder
      - does not gzip the file

  

  db:import (or db:imp)
  =====================
  Description: Import database dump file into the specified RAILS_ENV.  Select file with FILE=path/to/file.  If the file is gzipped, it will be unzipped, imported and then gzipped back again.

  Requirements:
    FILE=path/to/file
  
  Options:
    RAILS_ENV=production|development|test - the environment database that the dump file is loaded into (defaults to development)

  Examples:
    rake db:import FILE=db/development_db_name_dump.sql.gz RAILS_ENV=production
      - first gunzips "development_db_name_dump.sql.gz"
      - then imports sql file into "production_db_name" database
      - finally gzips the file back up for the next usage
      
    rake db:import FILE=db/development_db_name_dump.sql RAILS_ENV=test
      - imports sql file into "test_db_name" database
      - no gunzip or gzip takes place unless given a .gz file
      

Copyright (c) 2008 Elijah Miller / David Baldwin, released under the MIT license