TheGoldenAura

I want this at home :) huffingtonpost.fr/mobileweb/2013…

• Texas Science – News from the College of Natural Sciences » Blog Archive » Neuroscientist Takes the Quantified Self, and Own Brain, to the Next Level

@ownClouders e.g. Speed of webinterface and sync with sync-clients (move is a move and not a copy-paste)

After testing both Owncloud 5 and Seafile 1.6.0… the winner is #seafile (IMPOV of Dropbox alternative)

Flipboard(ing) TweetBot’s new “media timeline”.

Installed #owncloud 5 on my dedicated server. Testing and comparing it with #seafile.

…riodismoalternativoblog.wordpress.com/2013/04/19/per…

Code Dependency (by @marksiegal in @TheMagazineApp) the-magazine.org/14/code-depend…

m.slashdot.org/story/185041

kickstarter.com/projects/clint…

Most Projects On GitHub Aren’t Open Source Licensed flip.it/MVmkz

“Alemanha tem que decidir se quer sair do euro”, diz George Soros flip.it/Ar69e

A Good Death flip.it/9RgRB

Easily installed Debian “squeeze” on old iBookG4 and using it as a home server. Cool ;)

I’m at Wolfisberg (Carouge, GE) 4sq.com/XJ7pWr

I’m at Marché de Carouge (Carouge, GE) 4sq.com/10XkAkT

These last years, I have been using WordPress to create different kind of sites and hosting them on my dedicated server. Despite all kinds of security strategies with data replication on the hosting machine it is an obligation to maintain a good remote backup system.

I have been using different WordPress backup plugins and most of them run fine with small sites. However, it can be really painful to do backups with the available plugins (including both free and commercial ones) when you have big sites, I mean bigger than 8GB data per site. This is just my personal experience, but I have used “commercial paid pro versions” plugins like BackupBuddy, Simple Backup Ultra, BackWPup… and always had problems.

This week, I got a really scary server crash and… I realise I have “insufficient” backups…

So I decided to stop being lazy and to create a very simple shell script to do exactly what I need.

It is a very simple script that backups the WordPress database, backups all site files, creates a tar with all this data, uploads to a remote destination by ftp, keeping backups from the last 30 days. Feel free to reuse it:

#!/bin/sh
#
# Script for backup of WP sites (WPsite001, WPsite002, WPsite003…) with mysql database backup, all site files backup and ftp upload to remote destination

 

# Finds files older than 30 days and delete them find /bck/ -type f -mtime +30 -exec rm -f {} \;

 

 

# These lines create the backups folders, dumps mysql databases, copy wordpress files and create a tar

# WPsite001

mkdir /bck/mysql/ mkdir /bck/backup/

mysqldump -umysqluser -pmysqlpassword site001databasename > /bck/mysql/site001databasename.sql

mv /bck/mysql/ /bck/backup/mysql/

cp -r /wpsite001-rootfolder/ /bck/backup/

cd /bck/

tar -cvf backup-wpsite001.$(date +%Y%m%d-%H%M%S).tar /bck/backup/ rm -R /bck/backup/

 

# WPsite002

mkdir /bck/mysql/ mkdir /bck/backup/

mysqldump -umysqluser -pmysqlpassword site002databasename > /bck/mysql/site002databasename.sql

mv /bck/mysql/ /bck/backup/mysql/

cp -r /wpsite001-rootfolder/ /bck/backup/

cd /bck/

tar -cvf backup-wpsite001.$(date +%Y%m%d-%H%M%S).tar /bck/backup/ rm -R /bck/backup/

 

#
# Uploads (resuming) files to FTP server machine
#
ncftpput -u user -p password -R -z remote-adress /remotefolder/ /bck/
#

Œuf et vin (@ Gusto E Sole) 4sq.com/ZKYyoz

Intel wants to kill the traditional server rack with 100Gbps links flip.it/ebF0s

Goodbye Nice #epa2013 (@ Nice Airport Terminal 2 Lounge) 4sq.com/10S7Adt

Flight delayed, another night at Nice… WTF easyJet!!!

I’m at Le Marche (Nice, France) 4sq.com/10PFuPO

RT @briansuda: was going to recommend Google Fusion Tables, but stopped short given it probably won’t be around in a year or two.

“The Year of the Brain – Joint Symposium with European Brain Council” starting now #epa2013

EPA 2013 (d2) (@ Acropolis Convention Center) 4sq.com/XwPQsA

Check out Geppetto (5 rue Gioffredo, Nice) on @foursquare: 4sq.com/Oe4zl2

Very good food and very very friendly place. (@ Geppetto) 4sq.com/10Iv2JP

EPA 2013 (@ Acropolis Convention Center) 4sq.com/10niwSS

After trying different bck plugins for WP, I think I finally found the right one: BackWPup. wordpress.org/extend/plugins…

E assim deixamos andar o nosso país. arrastao.org/2784220.html

E anda assim o nosso país. aventar.eu/2013/04/02/ah-…