Skip to content

Rake tasks to dump and import various database batch files.

License

Notifications You must be signed in to change notification settings

harking/dumpimp

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

27 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

About

Rake tasks to dump and import various database batch files.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Ruby 100.0%