bfaloona / monologues

monologues rails website
0 stars 1 forks source link

create data backup automation #12

Open bfaloona opened 14 years ago

bfaloona commented 14 years ago

download copy of sql db

bfaloona commented 14 years ago

I marked steven as the owner because it would be good for you to know how to do this.

the process will change from heroku to godaddy, but still, you should be the master of your data.

setup instructions: install one-click-installer ruby for windows gem update --system gem install heroku

bfaloona commented 14 years ago

Heroku specific instructions http://docs.heroku.com/backups

Instructions for godaddy will be completely different. Probably running a sql utility via ssh.

bfaloona commented 14 years ago

I just tried this and will email you the backup.

~/Sites/mono (master) $ heroku bundles:capture --app monologues Began capturing bundle 2010-03-30 from monologues ~/Sites/mono (master) $ heroku bundles:download --app monologues Downloaded 4556099 byte bundle monologues.tar.gz

slshults commented 14 years ago

have stashed backup in a safe place.

close this? or leave it open as a rotating backup-early-backup-often reminder?

bfaloona commented 14 years ago

whatever you prefer. you should learn how to backup on heroku, then learn how on godaddy. then we setup a cron job on godaddy to backup once a __.

slshults commented 14 years ago

roger that.

slshults commented 14 years ago

looks like i need access to a prompt on heroku which as far as i know i don't have.

might you be so kind as to pull down a backup for me until we have a chance to connect to get the server and login info to me to ssh with?

are you ok with emailing the pw to me or do you prefer to exchange passwords via phone?

slshults commented 14 years ago

working on my machine. changing issue title to make it about automation on godaddy.

slshults commented 14 years ago

current manual backups working fine for pre-migration. automation would need to be recreated after migration so changing this to a post-migration item.

bfaloona commented 14 years ago

please test: 1) cap deploy:mono:backupdb 2) ftp to retrieve backed up db

slshults commented 14 years ago

will test tonight before launch.

slshults commented 14 years ago

1) success 2) success