racl101 + backup   68

Backup (mysql dump) all your MySQL databases in separate files - Running with Ruby
Really good, simple to understand Bash shell script demonstrating how to backup all the databases in a given mysql server installation into a single file or into separate files (one for each database).
blog  tutorial  howto  example  guide  reference  backup  export  database  dump  sql  files  shell  script  single  separate  mysql  bash 
november 2018 by racl101
Backing Up Mysql Databases Remotely Using cron & ssh - Andy Croll
Really good blog tutorial that demonstrates how to write a Bash Shell script to log into a remote server using SSH (by way of a previously set up public SSH key) and run the MySQL backup command (mysqldump) to create a database backup (or more), download those backups to the local machine, delete the no longer need backups remotely, and clean up old backups locally (based on an arbitrarily chose number of days to keep them) and how to set a Cron job to run this script regularly. Great tutorial.
Database  Shell  backup  Toread  Server  CRon  Remotely  Mysql  Linux  Script  mysqldump  Ssh  Blog  Bash  tounderstand  Howto  Tutorial 
october 2015 by racl101
How to use Cron to Backup CloudSites to CloudFiles | Cloud Computing and Web Hosting Knowledge Center by Rackspace
Could be useful if Crons actually fired off when they're supposed to. Probably won't work for a giant site. Nevertheless the Cloudfiles PHP API code was indeed useful and the Bash script can be made to work on a local machine.
example  howto  mysql  database  backup  tutorial  kb  knowledgebase  cloudsites  cloud  rackspacecloud  rackspace  cron 
march 2012 by racl101
Backup Your MySQL Database Using PHP
Looks useful especially if I don't have bash script privileges.
php  mysql  backup  database  howto  tutorial  db  code  david-walsh 
april 2010 by racl101

related tags

amazon  ansible  app  apple  applescript  apps  archive  automator  backup  backupbuddy  bash  blog  bookmarks  bundle  burning  business  carbon  catalog  cli  Clone  cloner  cloning  cloud  cloudsites  coda  code  commandline  commands  comments  computers  condition  cookie  cookies  copy  Create  cron  cronjob  cronnix  data  database  Dataonly  david-walsh  db  dbdump  delicious  delicous  design  development  directory  DNS  documentation  draft  drive  dropbox  dump  duplicate  dvd  dvdshrink  ee  email  error  errorcodes  example  examples  exclusions  explanation  export  expressionengine  file  files  Fix  form  forms  git  Gmail  google  group  guide  hardrive  horcrux  host  hosting  howto  Image  imap  import  iphone  issues  javascript  jquery  kb  knowledgebase  limit  linux  local  localhost  mac  machine  macos  macosx  mail  manage  managed  management  managewp  manpage  Manual  mbu  media  mediatemple  messages  migrate  migrating  migration  module  moving  mysql  mysqldump  mysql_backup  new  onLy  opensource  organization  osx  owner  pagodabox  paid  password  permission  permissions  php  plan  Plugin  Plugins  postgres  postgresql  procedure  product  Program  prompt  rackspace  rackspacecloud  recovery  reference  Remotely  repair  rescue  restore  rsync  s3  save  scm  script  scripts  separate  server  Service  shell  single  site  Snapshot  software  sql  Ssh  stackexchange  stackoverflow  storage  support  symlink  sync  sysadmin  tar  text  timemachine  tips  tolearn  tool  tools  toread  totry  tounderstand  transfer  trigger  troubleshoot  troubleshooting  tutorial  tutorials  twitter  unix  unixcraft  utilities  utility  vim  vimrc  web2.0  webdesign  webdev  webservices  website  whERE  wordpress  wpengine  wpmuorg  yojimbo 

Copy this bookmark: