Skip to content

Latest commit

 

History

History
40 lines (27 loc) · 1.5 KB

readme.md

File metadata and controls

40 lines (27 loc) · 1.5 KB
Raw

rdbsync

a quick and dirty ruby script to sync remote db via ftp for (php) web projects

It's common to keep local db in sync w/ production one, so if you're tired of one of these:

  • working with php cms (who doesn't have to, sometimes...) and deal with db upload/download on remote hosting services
  • open (awful and chunky) hosting web interfaces to deal w/ remote db(s)
  • launch local mysql client app or run commands to restore db, and do it repetitively

this supposed "hassle free" tool is for you...

usage

  • clone repo with git clone [email protected]:magnum/rdbsync.git
  • copy rdbsync.example.yml from the git cloned dir into your web project(s) directory, save it as rdbsync.yml and edit it accordingly to your project online url, local and remote db credentials: it's supposed to be self-explaining
  • USE IT, but make db backups before! :-)

PULL database, from remote to local

ruby rdbsync.rb pull

PUSH database, from local to remote

ruby rdbsync.rb push

Put a rdbsync.yml config file in every project you want to use with rdbsync. From inside your web project root, call rdbsync.rb specifying the its path, ie:
ruby $HOME/projects/rdbsync/rdbsync.rb push

If you want, you can make it executable with chmod +x rdbsync.rb and call it directly

rdbsync.rb push

next steps

  • error handling
  • credentials checking routine
  • backup before db overwrite
  • testing

Help or suggestions are appreciated

Antonio Molinari (for friends, Magnum) [email protected]